Help writing SQL syntax

[willrs]

[ FlexSim 23.0.15 ]

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.

problem-sql-syntax.fsm

[moehlmann_fe · Accepted solution]

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.

[willrs]

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!

[Jeanette_Fullmer]

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.

[willrs]

Okay, I understand

Thanks!