I assume there is internally a list, on which query methods of warehousing work. Does there exist a possibility to view the entries?
@Jörg Vogel Unfortunately, I don't think there is a way to do that right now.The current method is to open a script window and do queries. I have used the warehouse stuff on a few projects recently and was surprised that it didn't use lists. It was done this way for speed purposes. We have had internal discussions with the FlexSim Dev team about this and agree that it is a needed feature. I would personally like a set of warehouse activities similar to the list activities. I would assume that this will be a priority for them shortly if they haven't started already. @anthony.johnson anything to add?
While there's not a specific tool for this (we hope to add that soon), there's not much you can't do if you have a script window and a little creativity.
First, you can use Storage.system.querySlots() and Storage.system.queryItems() to query the slots/items in your system, using any desired query. These methods return an array of slots/items.
Now you have an array, but you want to get more information about each slot/item. Well, you can interpret the array as a table, and then clone it to a global table. Once it's in a global table format, you can use Table.query() to get any other information you want about the slot/item.
The code for this would look something like the following:
string slotQuery = "ORDER BY Type"
Array slots = Storage.system.querySlots(slotQuery);
Table tempTable = Table("Temp");
Table(slots).cloneTo(tempTable);
tempTable.setColHeader(1, "SlotRef");
Table.query("SELECT Temp.SlotRef, Temp.SlotRef.Type? AS TypeLabel, Temp.SlotRef.as(Storage.Slot).bayID AS Bay, Temp.SlotRef.as(Storage.Slot).levelID AS Level FROM Temp").cloneTo("TestSlots");
And an example model.
Many thanks for your effort, Anthony. I have tried it the other way around. I identify the slots of rack objects in the tree by join clause of the tree structure. See my answer to convert rack bays to table. If I need the slots of all racks, I have to evaluate the coupling nodes of StorageSystem under Tools in model tree and include them in the join clause.
But I don't know which approach is faster.
15 People are following this question.
