topic Re: How can I query with dynamic argument when querying resource in processflow in FlexSim Forum

How can I query with dynamic argument when querying resource in processflow

thijs_damsma — Thu, 23 Feb 2017 14:03:00 GMT

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

Re: How can I query with dynamic argument when querying resource in processflow

mischa_spelt — Thu, 23 Feb 2017 14:22:03 GMT

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)?

Re: How can I query with dynamic argument when querying resource in processflow

thijs_damsma — Thu, 23 Feb 2017 14:38:56 GMT

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!

Re: How can I query with dynamic argument when querying resource in processflow

thijs_damsma — Thu, 23 Feb 2017 14:41:04 GMT

All of a sudden it works as expected, I cannot reproduce whatever went wrong before.

Re: How can I query with dynamic argument when querying resource in processflow

mischa_spelt — Thu, 23 Feb 2017 17:00:16 GMT

Hmm weird. Maybe @anthony.johnson can have a look and see whether e.g. the capital P in the default option is the culprit.