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.
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.
Storage.system.queryItems("SELECT item, time()- get(stats_lastmovetime(item.item)) AS Age WHERE Age>hours(5)").as(Array).as(Table).cloneTo(Table("GlobalTable1"))
Hi Steven, that was my alternative option but I didn't want to do this becasue to me that's creating another list next to one already existing which has the data. Jasons answer helps me out. But thanks for your input.
Hello
@Jason Lightfoot it would be possible to do a query of multiple items to the storage system, like if it was a pull from list with require number = 30 for example?
