topic Re: Pull from List query with multiple conditions in FlexSim Forum

Pull from List query with multiple conditions

ssrdh — Tue, 25 Apr 2023 22:28:51 GMT

[ FlexSim 22.2.4 ]

Hi,

I was wondering if there is a way I can pull from list using multiple creterias. My puller token is an item consisting of labels: "aisle_id" and "bay_id"

My list consists of all Racks which has labels: "bay_id", "aisle_1" and "aisle_2".

I want to use AND and OR functions in the same pull query, something like:

WHERE bay_id = Puller.bay_id && (aisle_1 = Puller.aisle_id || aisle_2 = Puller.aisle_id)

With this query, the pulled value matches the first creteria but is not matching the second creteria (the one with and OR condition in brackets). In addition I am also getting this error in the console:

Is this the correct format to use for the Pull query?

Thanks,

Re: Pull from List query with multiple conditions

jason_lightfoot_adsk — Tue, 25 Apr 2023 23:03:29 GMT

No - you're using a version of SQL, so you should use AND and OR rather than && and ||.

Re: Pull from List query with multiple conditions

Jeanette_Fullmer — Wed, 03 May 2023 02:27:01 GMT

Hi @Aditya S2, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.