question

Tamilselvan avatar image
0 Likes"
Tamilselvan asked Tamilselvan commented

Access token label using SQL

Its possibe to access the label of token using SQL


Thanks in advance

FlexSim 23.1.1
sql
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·

You should provide better context for this question - what are you trying to do; during what type of event, and what do you mean by 'access'?

0 Likes 0 ·

1 Answer

·
Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered Tamilselvan commented

In pull activities it is the Puller field value that can parse reference of a token into a query clause. Or you can parse by $ enumerated integer value a reference into a query clause called as additional parameter. Once you have a reference to a token, then you can use the dot-syntax to access labels of this parsed reference.

https://docs.flexsim.com/en/23.1/Reference/ProcessFlowObjects/SharedAssets/PullFromList/PullFromList.html#properties

https://docs.flexsim.com/en/23.1/Reference/DeveloperAdvancedUser/SQLQueries/SQLQueries.html#example

· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Felix Möhlmann avatar image Felix Möhlmann commented ·

Since their previous question deals with storing tables as a label, I assume the goal here is to query that table label. (As Jason said, please try to always provide enough context so that the question can be understood on its own @Tamilselvan)

This can be done by passing the label node into the query as a parameter with the $-syntax.

1691484802504.png

2 Likes 2 ·
1691484802504.png (36.8 KiB)
Tamilselvan avatar image Tamilselvan Felix Möhlmann commented ·
Thanks
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.