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

Question

question

Cameron Pluim asked Jun 23 2016 at 7:31 PM Cameron Pluim commented Jun 24 2016 at 12:32 PM

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

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?

Software Version:

FlexSim 16.0.1

process flow labels query lists

works.jpg (81.9 KiB)

doesntwork.jpg (84.8 KiB)

· 8

Phil BoBo ♦♦ commented · Jun 23 2016 at 7:33 PM

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

1 ·

Cameron Pluim Phil BoBo ♦♦ commented · Jun 23 2016 at 7:37 PM

the first query also works if it is

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

0 ·

Phil BoBo ♦♦ Cameron Pluim commented · Jun 23 2016 at 7:40 PM

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

2 ·

903-doesntwork.jpg (86.4 KiB)

Show more comments

Cameron Pluim commented · Jun 23 2016 at 8:02 PM

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

0 ·

pulldoesntwork.fsm (49.0 KiB)

pullworks.fsm (49.0 KiB)

Jeff Nordgren Cameron Pluim commented · Jun 23 2016 at 8:09 PM

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

0 ·

Cameron Pluim Jeff Nordgren commented · Jun 24 2016 at 12:32 PM

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.

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2016-06-23T20:09:53Z

Phil BoBo answered Jun 23 2016 at 8:09 PM Cameron Pluim edited Jun 24 2016 at 12:29 PM

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.

· 2

question