Bug #62173 Add a "GoTo" option in the feature to Find in Result Set
Submitted: 15 Aug 2011 20:17 Modified: 16 Aug 2011 14:38
Reporter: David Berg Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.34 CE OS:Windows (XP Pro SP3)
Assigned to: CPU Architecture:Any

[15 Aug 2011 20:17] David Berg
The FIND feature in Result Sets compresses the Result Set to only the rows that contain the Search String. This is probably satisfactory for most applications of this feature, but I have the need for an extension of that feature.

A script I regularly execute creates a log. The log may contain anywhere from a thousand rows to well over ten thousand rows. 

When I issue a FIND on a particular string in that log, I like seeing the compressed list of rows containing the Search String, but I would then like to be able to "GoTo" any one of those rows and have the list revert to the full result set (in the order selected), but pointing to the row I choose from the FIND set.

How to repeat:
SELECT the contents of any table.
Issue a FIND of some known string within the result set.

Suggested fix:
Alternative 1 ... Add a GoTo feature, where the 'found' list reverts to the full result set (in the order selected), starting at the row I select from the 'found' list.

Alternative 2 ... Add a second FIND feature that highlights all rows in the result set containing the Search String, much as does the FIND feature in Query Browser.
[16 Aug 2011 14:38] Valeriy Kravchuk
Thank you for the feature request.