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