• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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