topic Is there a way to query a list of task executors by closest distance to puller? in FlexSim Forum

Is there a way to query a list of task executors by closest distance to puller?

kari_payton — Thu, 02 Feb 2017 16:10:20 GMT

[ FlexSim 17.0.1 ]

querylist.fsmI had a list of 72 operators avaivable on a list and 8 different fixed resources that pull the operators they need from the list for different sub processes. In real life the operators closest to the fixed resource will work in that location. Is there a way to use the query list option for this?

Re: Is there a way to query a list of task executors by closest distance to puller?

anthony_johnsonT83CM — Thu, 02 Feb 2017 16:25:09 GMT

You should be able to just pull from the list with the query: ORDER BY distance, as distance is one of the fields you get with a task executer list. You may need to adjust the distance field's code if you have some weird scenario, but in general it should just work.

Re: Is there a way to query a list of task executors by closest distance to puller?

kari_payton — Thu, 02 Feb 2017 16:46:26 GMT

Hi @anthony.johnson I created a model example. I am getting an error on the distance field code. querylist.fsm

Re: Is there a way to query a list of task executors by closest distance to puller?

jeff_nordgren — Mon, 06 Feb 2017 12:10:15 GMT

@anthony.johnson,

In her model when I look at the entries in the List, under the column header "distance", it just says "Puller Required". Should that be a number of some kind? Is that why there are a bunch of errors when the pull is ORDER BY distance ASC?

Re: Is there a way to query a list of task executors by closest distance to puller?

jon_abbott — Fri, 04 Dec 2020 00:45:21 GMT

Hi @anthony.johnson and @Jeff Nordgren, I am encountering the same issue in FlexSim 2020 - pulling by distance doesn't seem to work, and all of the list entries just say "Puller required" even after an item has been pulled. I changed the puller to refer to the token label that refers to the other object, and have also tried setting it to leave items on the list, but nothing seems to work. Is there an example model somewhere for this that I can refer to?

Re: Is there a way to query a list of task executors by closest distance to puller?

jason_lightfoot_adsk — Fri, 04 Dec 2020 01:02:52 GMT

When you open the list entries look over at the quick properties where you can define the puller using the sample or typing an expression. Selecting your puller will let you see if the "puller required" is replaced with the correct distance expression.