I have a token with a label (type array) containing some values. I want to acquire the values in this array from a resource by an "Acquire Resource" activity. I type in the Query "WHERE value IN token.arraylabel" but it throws an exception. What is the correct expression?
Thank you,
Jarek
In list queries there is no locally accessible "token" keyword. There is only "value" and "puller". The problem is that, with a list of tokens, tokens are often both the values and the pullers, so in this context a "token" could be ambiguous. I think what you need is:
WHERE value IN puller.arraylabel
You need to make sure that the puller you pass in (it's a setting on the Pull From List activity) is the object (or token) that has the label with the array on it.
Hi @anthony.johnson,
Thank you. I made a work around because my array consists of objects and not strings. Puller.arraylabel seemed not to work in that case (hard to tell because SQL doesn't give explanations to errors).
So I made a subflow and I defined a label array_index with value: array_index.length.
Then I grabbed the object.name in the array and decremented the array_index with -= 1.
With that string I then got my resource entering WHERE value=object.name in the query field.
A simple condition statement was added to check if the array_index is not zero completed the "for loop".
This is not a clean solution but it will do for the mean time.
I'm not quite sure what you mean by "acquire the values in this array from a resource." The query field in the acquire resource is for querying for objects withing that resource group. You can query by any of the fields you have set up for that resource group. (These could be labels on the object, which you then add as a field to your resource. To do this click on the Advanced tab in your Resource properties, and you'll see a window where you can add and define fields that can be queried in your Resource group.)
To get values from a label array, you'll need to find another way to parse through them, such as a 'for loop.' Or perhaps you could add a label array to a table and then query the table.
Thank you for your answer. I will explain you the situation more clearly.
I have a resource activity that contains a group of 3D objects. I have a token entering an Acquire Resource activity which has a label with type array containing 3D objects. I now want to pull the objects from the resource that match with the ones in the array. Can I do this with SQL? Or should implement a forloop somehow.
10 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
