I have a list with a label called zones and it is an array of values for example two tokens on the list
1.) zones = (1,2,5,7)
2.) zones = (8,5,6)
the token that is pulling from the list has a fixed zone for example zone = 1. I want that token to look in the list and look in the arrays and pull the token number 1 because it has a 1 in the array.
I tried but it doesnt work
WHERE zones IN puller.zone
Hi @Jason P2, was Ryan Clark's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
Hi @Jason P2,
You have the query almost right. You just have to switch your arguments because you want to pull the token if the zone on the puller is IN the array of zones on the pulled token.
So, the query should be WHERE puller.zone IN value.zones.
I hope this helps! Let us know if you have further questions!
14 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.
