question

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