Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 325317

Summary:

results view should allow for multiple results

Product:

[Tools] Data Tools

Reporter:

arne anka <eclipse-bugs>

Component:

SQL Results View

Assignee:

dtp.sqldevtools-inbox <dtp.sqldevtools-inbox>

Status:

RESOLVED WORKSFORME

QA Contact:

Severity:

enhancement

Priority:

CC:

bpayton

Version:

unspecified

Target Milestone:

1.8.2

Hardware:

All

OS:

All

Whiteboard:

Attachments:

Description	Flags
Screen capture of result history in the SQL Results view	none
Screen capture of reorganized SQL Results view	none

Description arne anka

2010-09-15 04:35:45 EDT

Build Identifier: I20100608-0911

i'd like to be able to see results of older queries, but the results view only ever displays the most recent result.
a tab name of "Result1" indicates that it should be possible to get more results than just that one, though.

Reproducible: Always

Comment 1 Brian Payton

2010-09-22 20:15:56 EDT

Something is wrong here.  The SQL Results view has always supported showing a history of previous results.  I'm adding an attachment that shows this.

The "Result1" indicates that there can be more than one result set associated with the same Run operation.  That can happen with certain database (such as DB2) that can return multiple result sets from one stored procedure.

Comment 2 Brian Payton

2010-09-22 20:16:50 EDT

Created attachment 179427 [details]
Screen capture of result history in the SQL Results view

Comment 3 arne anka

2010-09-23 03:11:35 EDT

i think, we speak of different features.
when you say "history", you probably refer to the left part of your screenshot, the table with "Status", "Operation", "Date" ...

but that's not what i meant: i'd like to see more tabs to the left ("Result2", "Result3", ...), each containing the _actual_ result of previous results, like QuantumDB does for instance. That way i, for example, easily could switch between different results for a slightly modified query.


as i see now possible by clicking a history entry (not very obvious), but the usability is very limited not at least because of #325106, since i, for example, use "Vertical View Orientation" and have resized the "Status"/"Result" part to cover the history to make as much use as possible of the very limited screen space.

Comment 4 Brian Payton

2010-09-24 20:13:01 EDT

Created attachment 179554 [details]
Screen capture of reorganized SQL Results view

Comment 5 Brian Payton

2010-09-24 20:15:36 EDT

Here's my suggestion:
1. Use the Horizontal View Orientation
2. Make the History section very narrow
3. Use the "Display result in a single tab" option.  This hides the Status tab when there is a result set

This allows you to rapidly switch between result sets with maximum space for the results.  See the attached screen capture.

Comment 6 Brian Payton

2011-02-18 19:39:04 EST

Closing with the suggested work-around.  We don't have the resources to do a major rework of the SQL Results view.  (Unless someone volunteers to contribute the code ... :-)