topic Re: "ORDER BY Distance" query does not work in "Find Slot" in FlexSim Forum

"ORDER BY Distance" query does not work in "Find Slot"

yokota_t — Fri, 05 Aug 2022 07:17:48 GMT

[ FlexSim 22.2.0 ]

Hello, all.

In the property of Find Slot activity, I set the query to "ORDER BY/ Distance from Object."

However, when I ran the simulation, an exception occurred. The message is as follows.

time: 10.859958 exception: SQL Evaluation Exception: FlexScript exception thrown in evaluation of code. Code is: ((param(1).as(Storage.Slot).location.project(param(2).as(Storage.Slot).storageObject,model())) - (param(3).as(Object).location.project(param(4).up,model()))).magnitude. Forwarding throw.
time: 10.859958 exception: SqlQuery - FlexScript Exception in: ORDER BY (slot.location.project(slot.storageObject, model()) - $1.as(Object).location.project($1.up, model())).magnitude ASC

I think it is because the query assumes that $1 contains token.item, but the default $1 contains token.

Thank you.

Re: "ORDER BY Distance" query does not work in "Find Slot"

kavika_faleumu — Fri, 05 Aug 2022 20:22:10 GMT

Hey @Yokota T, it's true that in the sorting algorithm,

ORDER BY (slot.location.project(slot.storageObject, model()) - $1.as(Object).location.project($1.up, model())).magnitude ASC

the $1 is assumed to be something that can be interpreted as an Object (hence the ".as(Object)"). Although the $1 parameter defaults to token, you can change it to be whatever you'd like. In the picklist next to the $1 parameter, you can click on Token >> item to change it.

You can use any of these possibilities; however, it's up to the person building the model to know what to put there. Flexsim was built trying to avoid making any assumptions about what the user may want to put. We just try to provide a framework for you to build models effectively 🙂

Re: "ORDER BY Distance" query does not work in "Find Slot"

yokota_t — Mon, 08 Aug 2022 08:51:15 GMT

@Kavika F , Thank you for your response. That makes sense. This notation is easier to change if the label name is other than "item."