topic Re: Can I query from a list using a value from a label? in FlexSim Forum

Can I query from a list using a value from a label?

cameron_pluim — Thu, 23 Jun 2016 19:31:55 GMT

[ FlexSim 16.0.1 ]

I have a tugger that is searching for objects that it can pick up, but it has to be able to fit on the tugger's train, and be scheduled to be picked up by that specific tugger. I assumed the following code would work:

It doesn't ever pull anything, but when I put in the values (instead of the FlexScript queries) it works e.g:

Note that current in the first section points to the tugger object that has the labels.

How can I reference these labels within the query? Do I need to put them on the token instead of on the object?

Re: Can I query from a list using a value from a label?

philboboADSK — Thu, 23 Jun 2016 19:33:55 GMT

Your first query seems to be missing a ) after "Equipment". Maybe that's why?

Re: Can I query from a list using a value from a label?

cameron_pluim — Thu, 23 Jun 2016 19:37:57 GMT

the first query also works if it is

 WHERE Equipment = "Tugger1" AND Length < getlabel(current,"AvailableLength")

Re: Can I query from a list using a value from a label?

philboboADSK — Thu, 23 Jun 2016 19:40:12 GMT

Does it work if you change it from getlabel(current,"Equipment" to getlabel(current,"Equipment") ?

Re: Can I query from a list using a value from a label?

cameron_pluim — Thu, 23 Jun 2016 19:44:28 GMT

Since I currently only have 1 tugger in the model, I have taken that out completely, and just have:

WHERE Length < getlabel(current,"AvailableLength")

And this doesn't work, but

WHERE Length < 15

does work. So I don't think the typo on

getlabel(current,"Equipment"

missing a ) is the issue.

Re: Can I query from a list using a value from a label?

philboboADSK — Thu, 23 Jun 2016 19:46:20 GMT

Can you post an example model so that we can debug what is happening?

Re: Can I query from a list using a value from a label?

cameron_pluim — Thu, 23 Jun 2016 20:02:49 GMT

Here's the 2 examples of each. The model doesn't work beyond the pull in either of them, but it does pull correctly in the example that doesn't use the getlabel() command. The only difference between these 2 is that the pull from list uses Length < 15 in the one that works, and Length < getlabel(current,"AvailableLength") in the one that doesn't work

pulldoesntwork.fsm

pullworks.fsm

Re: Can I query from a list using a value from a label?

jeff_nordgren — Thu, 23 Jun 2016 20:09:21 GMT

Cameron, what if you set a Global Variable to getlabel(current,"AvailableLength") and then used that Global Variable in the Query?

Re: Can I query from a list using a value from a label?

philboboADSK — Thu, 23 Jun 2016 20:09:53 GMT

Looking into this, in the Query field, you don't have access to "current".

You only have access to "value" and "puller". In your case, puller is the entering token, so you would need to either change puller to the tugger, or get a reference via the token.

Re: Can I query from a list using a value from a label?

anthony_johnsonT83CM — Fri, 24 Jun 2016 03:47:29 GMT

Also, in list SQL, getlabel(puller, "labelName") is the same as puller.labelName, and getlabel(value, "labelName") is the same as value.labelName is the same as labelName.

Re: Can I query from a list using a value from a label?

cameron_pluim — Fri, 24 Jun 2016 12:28:49 GMT

I was able to change puller to current, and then use puller.AvailableLength (as Anthony said above)

Thanks!

Re: Can I query from a list using a value from a label?

cameron_pluim — Fri, 24 Jun 2016 12:32:46 GMT

Jeff, I could have set a Global Variable, but I would need a Global Variable for each instance of this Process Flow (maybe a Process Flow Variable would be better). I think the better solution (in order to keep the information on the tugger itself) is to change puller to be current (as stated by Phil), then I have access to the puller's labels.