Pull from List query with multiple conditions

Question

question

Aditya S2 asked Apr 25, '23 Jeanette F commented May 3, '23

Pull from List query with multiple conditions

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,

Software Version:

FlexSim 22.2.4

pulling from lists

1682461653632.png (10.1 KiB)

· 1

5 |100000

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

Jeanette F ♦♦ commented · May 03, 2023 at 02:27 AM

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.

0 ·

Answer 1 · 2023-04-25T23:03:29Z

Jason Lightfoot answered Apr 25, '23

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

5 |100000

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

question