query slot by classtype of storageObject

Question

question

Xu Chunqi asked Jul 23, '20 Xu Chunqi commented Jul 24, '20

query slot by classtype of storageObject

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.

Software Version:

FlexSim 20.1.3

flexsim 20.1.3 query slot

· 2

5 |100000

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

Joerg Vogel commented · Jul 23, 2020 at 09:12 AM

@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!

0 ·

Xu Chunqi Joerg Vogel commented · Jul 23, 2020 at 09:34 AM

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.

0 ·

Answer 1 · 2020-07-23T13:16:03Z

Joerg Vogel answered Jul 23, '20 Xu Chunqi commented Jul 24, '20

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);

· 1

5 |100000

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

Xu Chunqi commented · Jul 24, 2020 at 01:15 AM

Hi Joerg, thank you very much!

0 ·

question