In query editor, ability to use "parameter-only" comparison in filter condition [DONE]

In the query editor today, you can’t do things like “{Parameter} equals (empty value)”. You always have to choose a data column when you filter, you can’t choose a parameter direclty.

It would be good to enable this because in this case we could handle optional parameter : a parameter becomes optional if you say “your_column equals {Parameter} OR {Parameter} equals (empty value)”.
That can’t be done today.

Well with SQL Expression you can handle that but you know users are not always SQL experts.

Just in case, I want to bring this topic up and say that it’s now possible with the new “Custom SQL” condition type that allows inserting EasyMorph parameters:

And we are really fan of this feature !

1 Like