Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Suggestion#1 - Multiple collumn filter

cmmoreira's profile image cmmoreira posted 9 months ago in HeidiSQL portable Permalink

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's profile image ansgar posted 9 months ago Permalink

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's profile image RevitArkitek posted 9 months ago Permalink

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.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 9 months ago Permalink

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's profile image cmmoreira posted 9 months ago Permalink

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's profile image RevitArkitek posted 9 months ago Permalink

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

ansgar's profile image ansgar posted 9 months ago Permalink

@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's profile image cmmoreira posted 9 months ago Permalink

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.