pull from list from a queue

[ahmed160118]

Hi, I want to transfer objects in the queue based on tokens 
since the queue works as a list i made a  reference to the queue and quired 
WHERE BobbinType = token.BobbinType
but that doesn't work
i want the object transferred to have labels as the tokens

[joerg_vogel_HsH]

You haven’t access to token directly in a list query. You substitute token by puller clause and set token in Puller field. 
pull from list activity property 

[moehlmann_fe]

I think you might have misunderstood something. Yes, it is possible to query objects in the model with the Table.query() command, as explained under "Advanced Query Techniques" about halfway down this page.

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

This has nothing to do with the Pull from List activity though. It must be linked to a List activity which itself either links to a global list or represents an internal list (the repeated error message tells you this). Since you want to connect the 3D model and the Process Flow you want to use a global list. The queue pushes arriving items to that list (either in the Send to Port field or the On Entry trigger). A List activity in Process Flow is connected to that list. Then the Pull from List can be used to pull items off the list.

As @joerg_vogel_HsH mentioned, use "puller" in place of "token" and change the label the pulled value is assigned to. Since it's used in the Move Object activity later, "item" would make sense.

[ahmed160118]

thanks for your replies

i tried these parameter and passed "pull from list without errors but still struggling to move the objects

[joerg_vogel_HsH]

BobbinType = puller.BobbinType

puller substitutes any construct you put into Puller field. Then it will be parsed into a query clause by puller parameter. 

[ahmed160118]

i tried this query but i get a parsing error

[joerg_vogel_HsH]

Can you post them? Make the changes. Check if you have a field in your list called BobbinType after it gets populated. If it exists and contains valid values. You can restart FlexSim. Save model. Restart FlexSim. Load model. 

[ahmed160118]

sure

[moehlmann_fe · Accepted solution]

- Only push the items to the list in the Send to Port field OR the entry trigger. If you do both the same item might end up being pulled by two tokens.

- Query should be "WHERE BobbinType = puller.BobbinType"

- You need a valid expression (Object/Token + Label) in the "Assign To" field.