Dynamic values not working in custom SQL query.

Plasmic Studio Questions
1

Any reason why I can’t use dynamic values in custom SQL queries?

The first pic is an invalid query, while the second works fine.

image.png

image.png

2

I can get it to work when not using json directlly. There’s an issue with how this handles data I think. If I use a single string, I’m fine, whereas when I list several results it doesn’t work. If I paste this code output in the SQLL query, it works. :frowning:

image.png
image.png1356×479 51.9 KB

3

I suspect we’re not parameterizing array values into sql correctly… @icaro

4

@icaro helped me out and AFAIK this has been fixed. it’s working now!

5 
SELECT *
FROM x
WHERE id = ANY( {{ ARRAY_VALUE }}::uuid[] )

Is working for me

6

Oops, forgot to mention it here too.

7

P.S someone give Icaro a raise

8

:eyes:

9

well that’s great :smile: