antares icon indicating copy to clipboard operation
antares copied to clipboard

Manual filtering without having to write the whole query

Open D-nov opened this issue 2 years ago • 2 comments

Is your feature request related to a problem? Please describe. It's related to a bug report i already submitted, but do not know how to link it.

Describe the solution you'd like Add option to manually filter in tables. For example instead of using the predefined filter you should also be able to write something like " table_name like 'some%text' " in an input text field.

D-nov avatar Jul 22 '22 07:07 D-nov

Please can you explain to me in more detail what you mean?

Fabio286 avatar Jul 22 '22 07:07 Fabio286

When you click on the magnifying glass you get filter on column names (which is awesome), but instead of clicking on several filters when i need to do complex filtering i'd preffer to write the filter manually in a textfield.

Pretty much like when you write raw query, but without the boilerplate of it. Here is example:

  • Real query: " select * from table_name where condition_1 && condition2 || condition 3 && condition4"
  • what i expect to use instead the exisitng filtering or the long raw query is just "condition_1 && condition2 || condition 3 && condition4"" in a simple text input row.

For reference other tools like DBeaver have this feature. I cannot provide screenshot at this time.

D-nov avatar Jul 22 '22 08:07 D-nov