Access token label in SQL Query

Question

question

Tamilselvan asked Dec 28 2023 at 12:58 PM Jason Lightfoot commented Jan 04 2024 at 4:42 PM

Access token label in SQL Query

How to access the token label in the SQL query.

for example, comaparing the table value with the token.label

Software Version:

FlexSim 23.1.1

sql queries

· 1

______

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 · 2023-12-28T14:29:04Z

Jason Lightfoot answered Dec 28 2023 at 2:29 PM Jason Lightfoot edited Dec 29 2023 at 3:23 PM

What's the context of the SQL - a table query, or list pull?

In a table query you can either concatenate the value into the string or pass in parameters for the token. Normally you'll be using a field name in the table to match values:

Table result=Table.query("SELECT * FROM MyTable WHERE $1.myLabel=<TableField>",token);

where you'd replace <TableField> with the name of column you want to match.

In a list pull query you just need to refer to the token as puller:

WHERE puller.myLabel=<ListField>

again replacing <ListField> with the name of a field you've added to the list.

All of this is documented on this site and in the online documentation. Please go through all the tutorials.

· 2

Tamilselvan commented · Dec 29 2023 at 10:08 AM

Hi @Jason Lightfoot

I am trying to Filter Some (x) value in my global table using the sql query, but that (x) is in my token label, that specific value has to filtered in global table.

For Example

Let's Consider i have Value : Station_1 in my token label(token.Value), i need to access the token label in Sql query and filter the Station_1. I should not query with the specific keyword, it should take the value from label dynamically.

0 ·

Jason Lightfoot ♦♦ Tamilselvan commented · Dec 29 2023 at 3:19 PM

Please don't use Value as the label name - it's used elsewhere in FlexSim and additionally in the context of a label can seem meaningless (exception being monetary value).

If you want a subset of a global table containing rows where some column contains a value matching that of a token label, then I've already answered that above. If the fieldname is dynamic too then just concatenate that into the sql string in place of the <Fieldname> text, rather than typing a fixed field. If that fieldname has spaces then be sure to put [ ] around it.

Test this in a tiny example with a script in the script console or a custom code in a process flow and if it doesn't work for you post the example and we'll find out why.

1 ·

question