Amount of items by type in a Rack

Question

question

Felipe Capalbo asked Jan 24, '24 Jason Lightfoot edited Jan 24, '24

Amount of items by type in a Rack

I'm building a Reinforcement Learning model that has its observations based on the content of the available racks.

So far I found the following script to reference the number of items in the rack:

Model.find("Rack1").subnodes.length

That command provides me only the overall quantity of items. I want to have this informations separated by its Type, an Item Label, in a command. Is that a way to do that?

Parameter Table with the Parameters that references the rack content.

Software Version:

FlexSim 24.0.0

rack content

1706112124478.png (2.4 KiB)

Answer 1 · 2024-01-24T16:39:32Z

José Antonio MD answered Jan 24, '24 Felipe Capalbo commented Jan 24, '24

Hello @Felipe Capalbo ,

If you want to count filtering by object and type I would use the StorageSystem. Using this system, you could use more filters, grouping...

Variant itemsWH = Storage.system.queryItems("WHERE Type = $1 AND item.slot.storageObject=$2",0,2/*Type*/,Model.find("Rack2")/*Rack*/);
return itemsWH.length;

You have more options such as looping and counting, filtering by tree... but I think this one will work well for you.

I hope I have been helpful.

· 1

Felipe Capalbo commented · Jan 24 at 06:21 PM

Thank you!

0 ·

Answer 2 · 2024-01-24T18:27:13Z

Jason Lightfoot answered Jan 24, '24 Jason Lightfoot edited Jan 24, '24

Here's a one shot query to list all the types and quantities by storage object and place that information in a global table.

Storage.system.queryItems("SELECT item.slot.storageObject AS Rack, item.Type AS Type, count(*) AS Count  GROUP BY Type,Rack").as(Array).as(Table).cloneTo(Table("GlobalTable1"))

· 2

Felipe Capalbo commented · Jan 24 at 06:48 PM

Is there a way to fix the Rows position as the GlobalTable updates its values?

0 ·

Jason Lightfoot ♦ Felipe Capalbo commented · Jan 24 at 07:04 PM

You can try adding the clause to "ORDER BY Rack ASC, Type ASC" after the GROUP BY clause

1 ·

question