How to find all rows that is not it array

voinn_a

Greetings.
I run a query on a table that filters and displays an array of id.

After doing this, I feed the matched_users variable into the not in filter :

and get the following error:
ParseError: "Users.id" not in [{"receiver_id":6}], message=Type mismatch.

Thank you for your help!

arturosanz

You are trying to compare an integer (Users.id) to an object (an item of matched_users array). You should update the matched_users array extracting the values to get rid of the objects leaving only the integers. Use the GetValue function to do so.

By the way, why don't you just run one QueryAllRecords by joining the Users and Matching_Status tables and then perform the custom query directly with the fields you need from both tables? Doing so you won't need the matched_users variable.