Creating dynamic queries / parameterized queries

Hey community!

I want to be able to use this part without any quotes in the query. It is basically says IS NULL or IS NOT NULL without any quotes on it. How can I achieve this dynamically?

image

image

I tried to do it like this but this variable brings quotes around IS NULL or IS NOT NULL:

image

image

it shows like this on the overview though:

image

This basically blocks me from creating dynamic queries.

Thank you!

Welcome to the forum!
This has come up many times and if you search the forum for this topic you will find many responses / solutions

1 Like

@ScottR , I searched for it but I couldn't find any answers about how I should put the string
without quotes. Do you know any? :slight_smile:

It could be that queries are set as prepared statements so that when using that resource you may need to uncheck that box...in the resource...
Or you can try using .replace() on that param

1 Like