question

Julio R avatar image
0 Likes"
Julio R asked Julio R commented

Double Query

Hello,

I'm trying to query a list with a pull from list in ProcessFlow with two conditions, but it's not working. I guess I'm not using the correct Query. Both conditions work unless I put them together. How can I do this?

This is the Query. I also have doublequery.fsmattached the model

WHERE LLEGADA <puller.Salida, AND sku =puller.SKU

Thank you!

FlexSim 18.1.2
processflowquery
doublequery.fsm (21.6 KiB)
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

The comma is your enemy here. A single = is valid in SQL statements.

0 Likes 0 ·
Julio R avatar image Julio R Jason Lightfoot ♦♦ commented ·

Thank you!! I don't know how that got in there...

0 Likes 0 ·

1 Answer

Emily Hardy avatar image
0 Likes"
Emily Hardy answered

Is this what you are looking for? I changed the query to:

WHERE LLEGADA <puller.Salida AND sku == puller.SKU

13093-doublequery.fsm


13093-doublequery.fsm (21.0 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.