topic Help writing SQL syntax in FlexSim Forum

Help writing SQL syntax

willrs — Fri, 18 Oct 2024 21:32:06 GMT

[ 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

Re: Help writing SQL syntax

moehlmann_fe — Mon, 21 Oct 2024 06:03:14 GMT

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.

Re: Help writing SQL syntax

willrs — Mon, 21 Oct 2024 16:31:17 GMT

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!

Re: Help writing SQL syntax

Jeanette_Fullmer — Mon, 21 Oct 2024 19:15:55 GMT

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.

Re: Help writing SQL syntax

willrs — Mon, 21 Oct 2024 19:37:09 GMT

Okay, I understand

Thanks!