question

Kari Payton avatar image
0 Likes"
Kari Payton asked Kari Payton commented

Query resource group based on label array.

I have a group of cranes with label of their crane number. The token should be allowed to pull either crane number from the group. How can I get the "acquire" to query a label array. Acquire Resource from Array.fsm

FlexSim 21.2.4
sqlresourceacquire resourcearray
5 |100000

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

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Kari Payton commented

I took a quick look at your model. You are correct that you can query like this:

WHERE value IN some_array

I did notice one thing, though. The original query in the model says this:

WHERE setNum IN puller.stationPointer.craneSetRef

I think it's supposed to reference the craneSetNum label, since that label has array values:

WHERE setNum IN puller.stationPointer.craneSetNum
· 1
5 |100000

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

Kari Payton avatar image Kari Payton commented ·
ahhh darn. silly mistake. thank you!
0 Likes 0 ·