How to know which slot is be stored in warehousing?

Question

question

Sean asked Jul 21, '22 Felix Möhlmann answered Jul 21, '22

How to know which slot is be stored in warehousing?

Hi all,

I'm learning about warehousing model. I want to know which slot is be stored in warehousing. I know there are lots of Flexscripts about warehousing, but it's too complicated for beginner.

For instance, I want to get bay1_level5 information when this slot was be stored. how can I write using FlexScript? Thank's.

Software Version:

FlexSim 22.1.3

warehouse slot

warehousing.jpg (98.4 KiB)

Answer 1 · 2022-07-21T08:29:07Z

Felix Möhlmann answered Jul 21, '22

To query which slots currently hold items, you would use the querySlots method. It uses the SQL keywords 'WHERE' and 'ORDER BY' to filter the slots by given criteria. Inside the query 'slot' is defined as a reference to the currently queried slot. So you can use it to check properties of the slot, such as its bayID or the number of assigned items.

Storage.system.querySlots("WHERE slot.slotItems.length > 0")

This code would return an array of all slots that currently have at least one item assigned to them. This data could then be transferred into a more readable format like a table. An example of this can be found in the script console of the attached model. Note that I mention that the items are 'assigned' to the slot. This includes inbound and outbound items.

To know 'when' and item was stored, a statistics collector can listen to the 'On Slot Entry' event of the storage objects and store the relevant data (timestamp, bay, level, item) in its internal table. And then displayed in a dashboard.

storage_query_example_fm.fsm

1658391966001.png (7.4 KiB)

1658391979710.png (22.8 KiB)

storage-query-example-fm.fsm (43.6 KiB)

question