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?
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.
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/ .
13 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.
