question

Aries Vash avatar image
0 Likes"
Aries Vash asked Aries Vash commented

Pull Strategy using Pull Global ItemList, Query pulling multiple label

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.

1690428127115.png


Thank you for helping me out!

Pull ItemList.fsm

FlexSim 19.2.4
pull itemlist
1690428127115.png (146.2 KiB)
pull-itemlist.fsm (27.7 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.

1 Answer

Joerg Vogel avatar image
1 Like"
Joerg Vogel answered Aries Vash commented

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


· 1
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.

Aries Vash avatar image Aries Vash commented ·
@Joerg Vogel works great thanks
0 Likes 0 ·