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

Question

question

Yokota T asked Aug 5, '22 Yokota T commented Aug 8, '22

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

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.

Software Version:

FlexSim 22.2.0

query find slot

Answer 1 · 2022-08-05T20:22:10Z

Kavika F answered Aug 5, '22 Yokota T commented Aug 8, '22

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 :)

1659730806718.png (79.6 KiB)

· 1

Yokota T commented · Aug 08, 2022 at 08:51 AM

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

1 ·

question