Prev
Next
Forums Integration / Customization IPA/ProcessFlow

DME select criteria - two fields

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Terry P
Veteran Member
Posts: 234
Veteran Member
3/13/2008 7:40 PM

    Is it possible in the ProcessFlow String Wizard to make a "selection criteria" between two fields instead of just a field and a value? You can select a field from the drop down box for the one on the left, but the one on the right does not. When I tried to just type in the field name, it took it, but does not return the expected results.

    For example I want to select if: SOH-QTY < REORDER-POINT

    Shari
    Veteran Member
    Posts: 78
    Veteran Member
    3/13/2008 9:59 PM
      Hi Terry -

      You would need to say SQH_QTY
      -Shari
      Terry P
      Veteran Member
      Posts: 234
      Veteran Member
      3/13/2008 10:33 PM
        Why is that Shari? If I do a simple build with no selection, looking at the ProcessFlow string, the fields do not have an "underscore" between them. If I did a simple criteria using a value (which works) it displays as SOH-QTY > 0 so why would I change it to an underscore here. (and the field is SOH-QTY, NOT SQH-QTY").

        I know with Expression Builder when entering Javascript code you have to replace the "-"'s with "_", but not in the dme calls. Am I missing something else?

        Thanks for responding back.
        John Henley
        Posts: 3353
        3/14/2008 6:00 PM
          Terry, I think she was referring to SQL, not a DME string. The answer to your question is "no"--the &SELECT criteria is limited to literal values.
          I assume you're trying to do something like create a simple query to replace a reorder report, like IC225?
          Thanks for using the LawsonGuru.com forums!
          John
          Terry P
          Veteran Member
          Posts: 234
          Veteran Member
          3/14/2008 6:32 PM
            I was trying to do a ProcessFlow that would do something similar. I think I should do it in the branching though after doing a query. Just starting to get my feet wet with process flows.