Option clause for field filter in native SQL parameter

#1

Hi there, people!

Consider the following query, to bee run against the sample database:

SELECT ORDERS.*
  [[,CONCAT(ORDERS.ID, {{id}}) AS optional_column]]
FROM ORDERS 
WHERE {{id}}
[[AND id = {{id2}}]]
LIMIT 100

As the names suggest, one is a field filter (id), and the other is a common number filter (id2). Using the common filter, I’m able to show or suppres that last column if the user selects or not something:


But, when using Field fiter option, that can’t be done:


My sugestion is to make the Field filter work just like the common filter. That would give us users to show columns dinamically, according to the user input, when using also the Field filter, and not only using text / number / date.

#2

I just found this (I THINK he wants the same thing as me):

1 Like