Suggestion#1 - Multiple collumn filter

cmmoreira posted 1 month ago in HeidiSQL portable

Possibility to create filter by adding multiple columns with value:

Eg:

Tabel: ColA ||ColB || ColC || ColD ||

Filter:

  • Right click in ColA» Quick Filter » IN 19 » ADD COLA in ('19')
  • Right click in ColB» Quick Filter » = ZZZ » ADD COLB = ('ZZZ')
  • Right click in ColC» Quick Filter » LIKE %ZZZ% » ADD COLC LIKE '%ZZZ%'

Below recent filters will appears like this:

COLA in ('19') and COLB = ('ZZZ') and COLC LIKE '%ZZZ%'

Now i have to copy and past each filter to make 1 complete filter

HeidiSQL have a solution that passed by my eyes or is a good sugestion?

ansgar posted 4 weeks ago

If you want multiple columns per filter, then you would get just all columns, not just 3 or whatever. That's because there is no way to focus multiple cells in these grids.

RevitArkitek posted 3 weeks ago

I think this is a good suggestion. I would like to be able to combine multiple filters by using the popup menu instead of typing into the filter field. Currently, if you select a quick filter in pop up menu, it replaces what's already filtered. Thanks.

ansgar posted 3 weeks ago

If you press Shift combined with left mouse click on the quick filter item, HeidiSQL does not replace the current filter but appends the new one to the old, along with an "AND". This is a bit of a hidden feature, and I hope it spreads a bit when posting this here.

1 attachment(s):
  • quick-filter-combined
cmmoreira posted 3 weeks ago

Bug found!

If i made just like you said, shift+click, will add the filter (print With shift+click).

But, adding a filter such as "Like" or "=" (print Adding), when it show the messagebox to fill the parameter, will only add that filer and don't combine with the last sintax (print last).

3 attachment(s):
  • With-shift-click
  • Adding
  • Last
RevitArkitek posted 3 weeks ago

@ansgar Thanks for letting us know! Works for me.

ansgar posted 3 weeks ago

@cmmoreira can confirm that, and also Shift does not work in the "More values" submenu. Could you please file a bug report on Github?

cmmoreira posted 3 weeks ago

Yes, also with shift key pressed does not work with several (see print). Ok.

I will fill in bug section.

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