I have a set of resources that each have different capabilities, which I stored as an array of strings. With this, I want to query only the Resources that can handle the item (represented by a token). The following query works as expected:
WHERE "some_type" IN capabilities
But when I make the query dynamic, like so:
WHERE Puller.some_type IN capabilities
I can't get it to work. Also tried:
WHERE getlabel(Puller, "some_type") IN capabilities
which doesn't work either
Hi Thijs. Not sure if it solves the problem but at the very least should that not be "puller.some_type" (with lower-case p)?
Will give it a try. When defining a query a resource and setting a query, the default suggestion implies I need a capital P:
WHERE Puller.some_type < 10
Well, I tried lowercase and it worked, and then uppercase also worked. So it works now, no idea what went wrong before. Thanks!
Hmm weird. Maybe @anthony.johnson can have a look and see whether e.g. the capital P in the default option is the culprit.
All of a sudden it works as expected, I cannot reproduce whatever went wrong before.
6 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.
