In this model, trucks arrive and use docks for loading and unloading. At first, type 1 trucks arrive. However, when type 2 trucks arrive, they have priority for loading.
I tried to build SQL syntax by integrating WHERE with ORDER, but it didn't work.
Which token gets to acquire something first is controlled by the "Back Order Queue Strategy" you can set in the resource's properties.
It also takes the form of an SQL query ORDER BY clause where "puller" references the token. The following would allow tokens with a higher "Tipo" label to acquire a dock before others.
Thanks Felix, this worked!
But I have a question about how to write an SQL syntax, using WHERE and ORDER, directly in "Acquire". Isn't that possible?
Thank you very much!
Hello @WillRS,
The query on the acquire activity will be for the resources. The back-order strategy query will be for the tokens acquiring the resource. In the case that you want to order the tokens, you will apply a SQL query to the back orders like he described. You will find this in the advanced options for the resource.
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.
