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.