Prev
Next
Forums Integration / Customization S3 Customization/Development

DME Syntax

 4 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
kwisser
Basic Member
Posts: 12
Basic Member
3/14/2011 1:43 PM
    I am looking to find a way to use the OR operation in my web browser DME call.

    http://myhr.sjhsyr.org/se...68611&out=csv&DELIM=|&MAX=99999

    I would like modify the above search to select PO-NUMBER=868611 or PO-NUMBER=13.  I've tried using the plus (+) but I must be missing something.

    Thanks
    JudeBac
    Veteran Member
    Posts: 129
    Veteran Member
    3/14/2011 1:55 PM
      Hi,

      It should look something like this (PO number 999 or 777 or greater than 555)

      PROD=TEST&FILE=POLINE&FIELD=PO-NUMBER;LINE-NBR;ITEM&SELECT=PO-NUMBER=999|PO-NUMBER=777|PO-NUMBER%3E555&OUT=CSV&DELIM=~

      Jude
      TBonney
      Veteran Member
      Posts: 281
      Veteran Member
      3/14/2011 2:06 PM
        Yes, I was also going to suggest the pipe symbol (|) be used.
        kwisser
        Basic Member
        Posts: 12
        Basic Member
        3/14/2011 5:06 PM
          The pipe worked for me. Thanks.
          kwisser
          Basic Member
          Posts: 12
          Basic Member
          9/29/2011 7:58 PM
            Can someone tell me if this syntax works for Lawson 8 also? Or does it only apply to Lawson 9?