Add where condition only if param value provided

#1

Is it possible to do something like

SELECT * FROM user {%IF param1 %}WHERE username LIKE {{param1}}{%ENDIF%}

I want to add part of query dependent of a presense of the parameter value.

0 Likes

#2

Hi,

It’s currently not possible (without a workaround), but it’s in our plans:

0 Likes

#3

@arikfr thank you for reply. I’lll subscribe to github feature.

0 Likes