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
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
    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
      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
        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
          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?