Quick Filters - Not Working

[expired user #7263]'s profile image [expired user #7263] posted 11 years ago in Feature discussion Permalink
Hi,

I have been unable to get quick filters to work at all. When I run a query, and then right click on a cell in the dataset, the 'Quick Filter' option is always greyed out. Is there something I'm missing? This seems like it would be an incredibly useful feature!

I'm on version 8.0.0.4513

Thanks,
Greg
ansgar's profile image ansgar posted 11 years ago Permalink
The quick filters are only usable in the "Data" tab, not when you run a query in a "Query" tab.
[expired user #8144]'s profile image [expired user #8144] posted 8 years ago Permalink

Anse - any plan to change that ?

HS could detect if the WHERE clause is already specified:

  • if it is, add " [field] = [value] AND " after the WHERE
  • if it isn't, insert the WHERE clause at the end as it does with the Data tab.

Alternatively, the query could be changed to something like: SELECT * FROM (initial query) A WHERE <field> = <value>

The latter option is probably easier and cleaner as finding the right place to insert the additional filter may proven difficult (e.g. multiple WHERE's found or complex queries).

Please login to leave a reply, or register at first.