Pull Strategy using Pull Global ItemList, Query pulling multiple label

[an_lam2]

[ FlexSim 19.2.4 ]

Hi, I need help regarding the query to pull items from the item list. I would like to pull two types of items: items with Product Label Value 1 and Product Label Value 2 to queue 1, and items with Product Label Value 3 to queue 3.

I'm using the query "WHERE Product = 1 AND 2," but it doesn't seem to work. However, when I use "WHERE Product <= 2," it works. But in a future model that I will build, I may need to pull item labels like 2, 5, 7 and 9. So, I'm not sure if "WHERE Product <= " is the correct way to pull multiple label values.

Thank you for helping me out!

Pull ItemList.fsm

[joerg_vogel_HsH · Accepted solution]

Try it with a query clause of IN . It test against a set of values of an array Or comma separated values.

https://www.w3schools.com/sql/sql_in.asp

[an_lam2]

@Joerg Vogel works great thanks