Hi,
Is there a way to query items in a storage system by the the time they are stored in the storage objects? I want to create a shipping list of items based on item type and want to select items which are stored for more than x amount of time. All items are randomly stored across several floorstorages. I know how to use find item and query on item type but I can't figure out how to query the staytime.
Regards Dirk
Storage.system.queryItems("SELECT item, time()- get(stats_lastmovetime(item.item)) AS Age WHERE Age>hours(5)").as(Array).as(Table).cloneTo(Table("GlobalTable1"))
Hello @Begoña Espiñeira,
Storage.System.queryItems()
Searches for all items that match the query, so you could pull the first 30 that fit the query.
Hello @Dirk Boumans If you would create a token when an item is entering the storage system and you put the token on a list with the age field and a pointer to the item you have your list immediately without any other actions required. And you can easily query everything older than a certain age.
17 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
