topic Re: How do I find a slot ordered by distance to an object in the model? in FlexSim Forum

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

jamesriebau — Thu, 17 Feb 2022 17:24:50 GMT

[ FlexSim 22.0.0 ]

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

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

jason_lightfoot_adsk — Thu, 17 Feb 2022 17:42:31 GMT

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

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

jamesriebau — Thu, 17 Feb 2022 18:16:43 GMT

Thanks, that was easy.