Filter a table with an array

[Matt_Denham]

• Goal: I need to filter a table excluding records by an array generated by query

• Steps: Using the default filter in table using the operator ( is none of ) I have tried filtering with query results which appear in a array with double quotes.

ei [ "33" , "65"] but this does not work.

When you input manually and removed the double quotes it works.

ei [33,65]

See the screenshot below

How do you transform the the data to make this work and or is the a shortcode for this?

• Details:

• Screenshots:

• App json export: (here's how to get a json export)

[WidleStudioLLP]

Hello @Matt_Denham Welcome to Retool Community,

I saw your issue, and it looks like you're passing the values ["33", "65"] as strings in the "is none of" operator. Try passing them as numbers using the Number or parseInt function. Let me know if you need further assistance!