• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
Posts: 78
Veteran Member
3/13/2008 9:59 PM
Hi Terry -

You would need to say SQH_QTY
-Shari
Terry P
Veteran Member Send Private Message
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
Send Private Message
Posts: 3351
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 Send Private Message
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.