How can I query the slots of a storage system?

Question

question

Joerg Vogel asked Dec 19, '19 Benjamin W2 commented Jul 22, '20

How can I query the slots of a storage system?

I am looking for a string which find a slot availble ordered by

level,
bay,
slot or
not populated in a combined query or each attribute alone.

Additional I thought it would be easier to get access to some basic data like maximum number of slots or available slots in the storage system.

But I didn't find such data. All I achieved, was to query the rack structure to put all slot nodes into a global list. Then I evaluated the value in the list to get additional data for level, bay, slot and dynamic current content. I queried this global list by a standard string and casted the pulled value into the Slot Assignment Strategy in the Rack object to realize placing the items by level > slot > bay into the rack. Attached is an example model.

How can I achieve such strategie without nested for-loops or my approach with a global list inside the Slot Assignment Strategy?

Many thanks! Regards Jörg

list-query-warhouse-rack.fsm

Software Version:

FlexSim 19.2.4

warehouse findslot query slot assignment strategy

list-query-warhouse-rack.fsm (49.6 KiB)

Answer 1 · 2019-12-19T17:56:50Z

anthony.johnson answered Dec 19, '19 Benjamin W2 commented Jul 22, '20

Storage.system.findSlot("WHERE slot.slotItems.length < 1 ORDER BY slot.levelID ASC")

This will find an empty slot, ordered by level number.

Storage.system.findSlot("WHERE slot.hasSpace($1) ORDER BY slot.levelID ASC", 0, item)

This will find a slot that has space to place a specific item, ordered by level number.

I think all of the things you want to do can be done with the Storage.system.findSlot() method, without for loops or Table.query(). Also, although technically I don't think you need a list at all, even if you did, I would suggest not using tree-based traversals for access, but to use the Storage API. For example, the bay number can be accessed with the expression value.as(Storage.Slot).bayID. The level can be accessed with the expression value.as(Storage.Slot).levelID. The number of items in the slot can be accessed with value.as(Storage.Slot).slotItems.length.

See also this question., and the user manual.

· 5

Joerg Vogel commented · Dec 21, 2019 at 06:51 AM

@anthony.johnson, thank you, I get it now. I oversaw the important parameter “slot” in the manual and its importance inside of SQL clauses. “findSlot” method works in my source code. I was just confused by the nested “for-loop” structure source code in the Assign Slot Strategy in rack objects, because a findSlot method looks so more elegant to me.
Currently I am struggling with the picklist warehousing options, but that will be perhaps another question.

1 ·

Kyle Y Joerg Vogel commented · Mar 06, 2020 at 06:09 AM

Hi Vogel,

i got inspiration from your answers. I got another doubt, how to query if I want to find the least item type in a storage system? Could you please help? Thank you.

0 ·

Braydn T Kyle Y commented · Mar 06, 2020 at 02:07 PM

@Kyle Y

Please ask a new question. so we can help other users. Thank you!

0 ·

Victoria M2 commented · Jul 22, 2020 at 03:04 PM

I can't get it to work if I have more than one rack in the model!

Can you help me?

twoRacks.fsm

0 ·

tworacks.fsm (41.5 KiB)

Benjamin W2 Victoria M2 commented · Jul 22, 2020 at 03:30 PM

Hi @victoria.m2,

Go ahead and post this as a separate question. That will help us keep this forum more organized and help you faster.

0 ·

question