When I set this filter up no results are returned

Apologies, the code is actually:

a!queryFilter(
field: "c6",
operator: "in",
value: cast(97, local!myUsernameList)
)

Have you tried to add the typeof() function in the cast?

value: cast(typeof(97), local!myUsernameList)

Or define the portal report column as Text and have

value: apply(fn!tostring, local!myUsernameList)

as the queryFilter value. If local!myUsernameList is already Text, then no conversion is needed there.

Sorry, appears that 97 is the type number for Any Type. So of course no need to use typeof(). Can you convert portal report column and queryFilter value to Text and use that as basis for comparison?

Thanks for your suggestions Jack.

Unfortunately these don't seem to solve the problem. The first approach returns null when calling cast(typeof(97), local!myUsernameList) which makes sense based on your most recent comment.

With Approach two the returned value from the portal report always seems to be "Any Type" regardless of how I set the column on the report in portal. Do you know of a way I can cast this column (c6) to type text on the queryFilter?

Thanks

If we want to cast to Any Type, we could try something like:

value: apply(fn!cast(97, _), local!myUsernameList)

We may need to use the apply function as we are operating on a list. However, this may still fail as my testing shows that this command fails to modify Text types to Any Types.

And I still wouldn't want to use Any Type as a basis of comparison. No, we cannot cast that column to type Text in the Query Filter. We want to define that column as Text in the Portal Report.

Can you provide the output datasubset of the queryProcessAnalytics call, with that column defined as Text? Can you run typename or typeof on an entry in the c6 column to see if it really is an Any Type?

Hi Jack, thanks for your help above.

I've had a play this morning and realised that the type of c6 is actually 'User or Group'. It is only type 97 once its been rendered onto the sail grid. As the queryFilter executes before that the Any Type is actually irrelevant now.

My issue now comes from attempting to compare a list - local!myUsernameList (which is now a list of type User or Group). When I compare to, lets say local!myUsernameList[2] it works fine, but the query filter doesn't seem to like evaluating the list.

I also believe this is exclusively an issue with comparing the 'User or Group' type

That's interesting. Not immediately sure why that happens. I would stick to the strategy of defining the column as Text and having the username list also as Text.