find amount of items in queue by label

Question

question

larkint8328 asked Feb 3, '23 Jason Lightfoot answered Feb 6, '23

find amount of items in queue by label

I am trying to make an order system that has 3 different queues. The boxes in the queue has a label(Silo) to assign to its queue and an order label(Skid). for the order picking to begin the quantity of the order should be present so for example

order 1 has 4 boxes all in one queue. how can I sift through the queue until all 5 are found? I have tried some custom code but was never able to get what I needed, what is the best way to go about finding an amount of a label in a queue?

Software Version:

FlexSim 23.0.3

queryitems queue items find objects

Answer 1 · 2023-02-06T13:44:14Z

Jason Lightfoot answered Feb 6, '23

You can push the items to a list and then look for quantities you need for the order.

Take a look at the Opportunistic Combiner example which uses a product type to define the quantities, which you could change to instead consider order quantities.

Answer 2 · 2023-02-04T06:56:02Z

Joerg Vogel answered Feb 4, '23 Joerg Vogel edited Feb 4, '23

It is an exercise to explore features of Lists and SQL.
https://docs.flexsim.com/en/23.0/Reference/Tools/GlobalLists/FunctionalReference/FunctionalReference.html#QuerySyntax

section headline > Using the SELECT clause.

There are other mechanism to evaluate values of fields in a list for example by clause SUM(..). Because Lists correlates strongly with SQL you find articles both in manual and many here in this forum. The manual links for a better understanding of SQL as a language to www.w3schools.com/sql/ .

question