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

[thijs_damsma]

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

[mischa_spelt]

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

[thijs_damsma]

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!

[thijs_damsma · Accepted solution]

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

[mischa_spelt]

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