When use a query like: SELECT IF(field=0,‘something’,‘nothing’) as myData FROM myTable, the grid renders ok, but when I try to search data using the connector_text_filter or connector_select_filter I got an error! Is there a way to search data using an alias or something in the query?
Thanx!