• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization S3 Customization/Development

Filtering on related table

 4 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
kwisser
Basic Member Send Private Message
Posts: 12
Basic Member
3/15/2011 11:42 AM
Is it possible to filter a DME web browser query on a related table?  For example, I want to find all PO lines that have a null PO-USR-FLD-5. 

https://myhr.sjhsyr.org/s...!=%00&out=csv&DELIM=|&MAX=99999

When I run the above query, it never ends.  I've even let it run overnight and it doesn't finish.  I don't think it has anything to do with the size of the result set because I've also tried adding a condition to the &select to pull a hardcoded PO-Number.  From all my testing it seems to be directly related to the fact that my &select is referencing a related table.

Thanks
Shane Jones
Veteran Member Send Private Message
Posts: 460
Veteran Member
3/15/2011 7:26 PM
"Selects" on a related table has been discussed here before (it think)....   I remember having issues with this in a process flow once and had to do something else to make the DME work.   (I think it is sometimes a hit or miss issue.)  

You might want to rethink the DME to see if you can write it in another way - Maybe: PURCHORDER as the base table related to the POLINE???
Shane Jones
Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
** Teach others to fish...
kwisser
Basic Member Send Private Message
Posts: 12
Basic Member
3/15/2011 7:42 PM
That was the original idea, but if I use PURCHORDER as the base table, then it doesn't give me all the lines. It only gives me line #1. That's why I switched to POLINE as the base table so that I could get all the line numbers.
Shane Jones
Veteran Member Send Private Message
Posts: 460
Veteran Member
3/16/2011 1:18 AM
In Process Flow I could help because we could just write an SQL query node...   Not sure how to help with a custom page ...
Shane Jones
Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
** Teach others to fish...
kwisser
Basic Member Send Private Message
Posts: 12
Basic Member
9/28/2011 7:49 PM
I was wondering if queries like in the original post would also work on Lawson 8?