Skip navigation

Make SQL editable or add advanced options for attributes for View-based reports

score 10
You have not voted. Not Planned

The SQL generated from a View-based report sometimes needs to be tweaked or adjusted for various reasons. An example is when searching values for an attribute, using contains writes the query using a like condition, but does not take into consideration case.

 

where mc_host like '%host%' - Will only find values that contain host, but will not find Host or HOST

 

To find the word host in any case, this is required:

where lower(mc_host) like '%host%'

 

It would be helpful if the View-based query would allow for modifying the SQL statement with validation to confirm accuracy. An alternative to full editing would be to add additional string qualifiers within the Filter Advanced Settings to set the table attribute to lower when running a query.

Comments

Vote history