query slot by classtype of storageObject

[xucq]

[ FlexSim 20.1.3 ]

Hi

I want to query slot by classtype of storageobject. How to write the query sentence?

The usual query sentence is "Variant slots = Storage.system.querySlots("WHERE slot.levelID = "+level_id,0);"

Thank you.

[joerg_vogel_HsH]

@xu.chunqi, can you be a bit more precise what you want to achieve? What is level_id? - A label, a previous level. Do you want to get as a result an array of slots ordered in a special design? Thanks!

[xucq]

In my model, there are two classes of rack , one is Rack, the other is FloorStorage.

When I choose slot to store items, I want choose FloorStorage.

I want to use querySlots to find slot, but I donnot know how to write the query sentence.

[joerg_vogel_HsH · Accepted solution]

I suggest you choose the rack by name:

Variant slots = Storage.system.querySlots("WHERE slot.storageObject.name = 'FloorStorage1'",0);

or pointer

Variant slots = Storage.system.querySlots("WHERE slot.storageObject = $1",0,Model.find("FloorStorage1"));

or if you have more objects then with clause IN

Array myRacks = [Model.find("FloorStorage1")];
Variant slots = Storage.system.querySlots("WHERE slot.storageObject IN $1",0,myRacks);

[xucq]

Hi Joerg, thank you very much!