[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.

[John Rix]

I think the second request was misinterpreted here – the customer is asking that filters applied to a particular table are remembered for THAT TABLE so that when you return to that table after visiting another, the filter is restored automatically. They were not suggesting that one filter should travel between tables.

For what it is worth, I think the suggestion is a very good one and I would like to see it implemented myself. This would save me some hassle!

From a general standpoint, remembering the state of a table when switching between tables would really help with a lot of tasks. Specifically:

A) What filters are applied, as per above suggestion
B) Current sort column and direction
C) Current page of results being viewed (ie. first 1000 rows or latter)
D) Scroll position or selected row

Regards,
John

[John Rix]

Fantastic. I’ll check it out tonight. Thanks!

[John Rix]

Any reaction to the above suggestion?

Thanks,

John

[John Rix]

I have a similar issue to moijisi, where in the majority of tables I look at, I want to order the data in descending id order so that I can see the most recent records.

I do have an alternate suggestion that could easily be implemented in a generic fashion though – provide a preference option to define whether clicking a column name sorts the data in ascending or descending order first after having loaded the table data. Although this does mean I would need to load the table data twice, it is still better than the current situation where I have to load it three times to see what I want!

Thanks,

John

[Author]

Posts