Filter bar

[Aadarsh]

Hi,

Applying filters is simple. You don’t have to right click on column header every time and follow all these steps to apply a new filter.

You can just click on filter button in the toolbar and it will open up the dialog to apply filters. Choose the column header and write the respective filter to be applied.
Moreover not differentiating b/w quick brown fox and ‘quick brown fox’ is in order to give correct filter results. All mysql syntax compliant people will add %% at the beginning and end. Though a request to add %LIKE% in the dropdown can be considered but we can’t promise the timeline when we will be implementing it.

[John Rix]

I am aware of the filter button on the toolbar. However, this has several deficiencies:

1. Three steps are required before you can filter a specific column value – click the filter button, select the column from the drop down list (multiple clicks in and of itself), then click/tab to the Value field
2. Once you have set filters, you cannot use the filter button to edit them – it becomes a ‘Clear filters’ button which is not always what you need. At the very least there should be two separate buttons.
3. Once you have set filters, you can’t see what they are, other than by initiating the creation of an additional filter through right-clicking of a column header. Right now, this might seem trivial. However, if the suggestion in this issue (https://github.com/webyog/sqlyog-community/issues/2137) is to be implemented, this will become a bigger concern.

I would again stress that a filter bar where the filter values remain always visible and conveniently editable would be much more efficient than what we have now. Adding a %LIKE% option to the existing drop-down list would be a minor improvement, but I still consider currently functionality impractical.

Arguing about %%s is a separate matter and one I won’t bother getting into at this point.

To be clear, I have been a paying customer of SQLYog for many years now and am generally very happy with the application, so I don’t want to seem negative. It has served me very well. I just feel there is obvious room for improvement around the filtering facility.

[Author]

Posts