How do I find a slot ordered by distance to an object in the model?

Question

question

James Riebau asked Feb 17, '22 Jason Lightfoot edited Mar 2, '22

How do I find a slot ordered by distance to an object in the model?

Hello,

In my warehouse model I'm working on I'm trying to prioritize which slots are chosen to put pallets away in floor storage. I would like to order the slots by closest to the docks.

In my find slot task was trying to reverse engineer the query for ‘ORDER By Distance from Object', to change the object from current pallet to another object in the model, but I really don't have a clue how to do it. I placed a cylinder in the center of my docks that I want to use as my object to measure from.

Can anyone help me with this?

Thanks,

Jim

PutawayTest.fsm

Software Version:

FlexSim 22.0.0

warehouse findslot order by distance from object

screenshot-2022-02-17-115805.jpg (267.4 KiB)

putawaytest.fsm (948.3 KiB)

Answer 1 · 2022-02-17T17:42:31Z

Jason Lightfoot answered Feb 17, '22 Jason Lightfoot edited Mar 2, '22

You can add a second parameter and use the sampler to point it to the cylinder

- then you can use:

WHERE slot.Part == 0 AND slot.zoneID == $1.StorageGroup AND slot.hasSpace($1) ORDER BY (slot.location.project(slot.storageObject, model()) - $2.as(Object).location.project($2.up, model())).magnitude ASC

Or you can add a label on the item pointing to the cylinder and reference $1.yourlabel instead of $1 in the distance part:

WHERE slot.Part == 0 AND slot.zoneID == $1.StorageGroup AND slot.hasSpace($1) ORDER BY (slot.location.project(slot.storageObject, model()) - $1.yourlabel.as(Object).location.project($1.yourlabel.up, model())).magnitude ASC

putawaytest_jl.fsm

1645120122782.png (5.8 KiB)

putawaytest-jl.fsm (947.7 KiB)

· 1

James Riebau commented · Feb 17, 2022 at 06:16 PM

Thanks, that was easy.

0 ·

question