question

Jason P2 avatar image
0 Likes"
Jason P2 asked Ben Wilson commented

finding a slot by rack

I want to find a slot by a specific rack. I thought about using the aisleID in the query can someone look at my query in my model?


Find_Slot_By_Rack.fsm

FlexSim 20.2.2
FlexSim 21.1.0
flexsim 21.1.0
· 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.

Ben Wilson avatar image Ben Wilson ♦♦ commented ·

Hi @Jason P2, was jason.lightfoot's answer helpful? If so, please click the red "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 Likes 0 ·

1 Answer

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Jason Lightfoot edited

find-slot-by-rack_jl.fsmSomething has gone wrong with the AisleID for aisle 1's storage object. Use the property table of the rack and add the column for AisleID and set it to 1 (it shows as blank).

Then the correct query is:

WHERE slot.aisleID= $1 AND slot.slotItems.length =0



5 |100000

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