Prev
Next
Forums Integration / Customization S3 Customization/Development

Web Browser DME Calls

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
kwisser
Basic Member
Posts: 12
Basic Member
3/8/2011 7:10 PM
    I am trying to find a way to perform a JOIN through a web browser DME call.  I'm currently using:

    https://myhr.sjhsyr.org/s...ect=%28LAST-ACTIVITY>=03/08/2011%26LAST-ACTIVITY<=03/08/2011%29&out=csv&DELIM=|&MAX=99999

    I would like to join in the POLINE table on PURCHORDER.PO-NUMBER = POLINE.PO-NUMBER.  Can someone help me with that syntax?

    Thanks,
    Kevin
    JudeBac
    Veteran Member
    Posts: 129
    Veteran Member
    3/8/2011 7:36 PM
      Hi Kevin,

      We do not use lawson's PO. However, I usually use the Processflow IOS API Builder. This is an example:

      PROD=TEST&FILE=PURCHORDER&FIELD=COMPANY;PO-NUMBER;POLINE.ITEM;POLINE.ITEM-DESC-1;POLINE.ITEM-DESC-2&SELECT=LAST-ACTIVITY=03/08/2011&OUT=CSV&DELIM=~

      Jude
      kwisser
      Basic Member
      Posts: 12
      Basic Member
      3/8/2011 8:28 PM
        That idea worked perfectly. Thanks. I'm still fine-tuning my query though.

        Is there a way to rename the columns. So instead of displaying the column as PO-NUMBER I would do something like like Select PO-NUMBER as PONUMBER.

        I'm also curious how I can specify a blank in my "where" clause. I would have something like &select=PO-NUMBER=""

        Thanks again,
        Kevin