Bug #80050 Table data save refresh is not filtered where the filter is active.
Submitted: 19 Jan 2016 11:43 Modified: 21 Jan 2017 18:04
Reporter: Lee Butler Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.6 OS:Windows (10 (Presumed any OS))
Assigned to: CPU Architecture:Any
Tags: data, filter, result grid

[19 Jan 2016 11:43] Lee Butler
Description:
The title isn't very helpful I know. 

A mild inconvienience, but when a table in the result grid is edited and the changes applied, after the "Filter Rows" feature being used, when the table refreshes after the save, the table is no longer filtered, but the text in the filter box remains. 

Simply focussing the Filter box and pressing enter triggers the filter again, but it can be annoying. 

How to repeat:
1. Open a table with multiple rows of data
2. Use the "Filter rows" feature in the result grid to reduce the amount of rows visible.
3. Make a change to the table
4. Apply changes to the table
5. Wait for the table to refresh, and when it does, the result grid shows all rows, including ones which were filtered out. 

Suggested fix:
Get the results grid to reapply the filter after refreshing (or at the same time) if the filter was in use previously.
[19 Jan 2016 12:41] MySQL Verification Team
Hello Lee Butler,

Thank you for the report.
Observed this with WB 6.3.6 on Win7.

Thanks,
Umesh
[21 Jan 2017 18:04] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.9 release, and here's the changelog entry:

The Filter Rows value set in the Result Grid of a query was not reapplied
when the query was changed or refreshed.

Thank you for the bug report.