This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 144504 - [65cat] Display # of records displayed in SQL History window
Summary: [65cat] Display # of records displayed in SQL History window
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 blocker with 1 vote (vote)
Assignee: Jiri Rechtacek
URL:
Keywords: NETFIX, PATCH_AVAILABLE, UI
Depends on:
Blocks: 152828
  Show dependency tree
 
Reported: 2008-08-20 01:09 UTC by adam_myatt
Modified: 2013-05-22 02:34 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments
SQL History with count below the table (57.52 KB, image/png)
2008-09-24 01:07 UTC, John Baker
Details
proposed patch v1 (19.77 KB, patch)
2013-05-20 16:20 UTC, matthias42
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description adam_myatt 2008-08-20 01:09:41 UTC
[ BUILD # : 200808170243 ]
[ JDK VERSION : 1.6.0_07 ]

In the SQL History window, it would be helpful to have a static
non-editable display of the number of records currently displayed in
the grid.  It could be labelled something like "Total Records: #"
where # is the number of SQL statements displayed. If the results in
the grid are filtered using the COnnection dropdown or the Matching
SQL filter, the # should update as well. This feature would be useful
once more than 5-10 records are displayed
Comment 1 John Baker 2008-09-20 00:11:16 UTC
Helpful for user to show the count.

This change is the addition of a label below the table that displays a number of the count of SQL statements returned.
Comment 2 John Baker 2008-09-23 07:11:22 UTC
Alternatives to adding a label at the bottom of the table displaying the total #

- append the total # to the title of the dialog
- append the total # to the title of the row SQL
- add a tooltip to the title with the total #

Comment 3 adam_myatt 2008-09-23 13:21:59 UTC
quick comment regarding the alternatives mentioned... i would vote against the 'add a tooltip to the title with the 
total #' since the total would not be visible or obvious. Either of the other two options sound OK since the number 
would be visible.
Comment 4 David Vancouvering 2008-09-23 16:46:31 UTC
I don't understand what the "title of the row SQL" means?

If you do a label, if you have a long list you might not see the total at the bottom - wouldn't it make more sense to
put the total at the top of the table?

Thanks.
Comment 5 John Baker 2008-09-23 17:28:17 UTC
> - append the total # to the title of the row SQL

whoops, I meant to say meant to say...
- append the total # to the title of the  SQL column header

Even if there are more rows returned the Table doesn't resize.   A scrollbar appears, so a label could be added below
the Table.

I can provide some screenshots
Comment 6 John Baker 2008-09-24 01:07:34 UTC
Created attachment 70385 [details]
SQL History with count below the table
Comment 7 Jiri Rechtacek 2009-10-16 14:10:18 UTC
Reassigned to new owner.
Comment 8 matthias42 2013-05-20 16:20:40 UTC
Created attachment 134651 [details]
proposed patch v1

The attached patch does two things:

1. It shows the number of current rows in the list (matching the filter an selected jdbc url)
2. It fixes the problem, that the buttons on the right side of the list stretch, when the history dialog is resized.
Comment 9 Jaroslav Havlin 2013-05-21 08:20:00 UTC
Applied as http://hg.netbeans.org/core-main/rev/0cff7de737af
Thank you very much!
Comment 10 Quality Engineering 2013-05-22 02:34:52 UTC
Integrated into 'main-golden', will be available in build *201305212300* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/0cff7de737af
User: Jaroslav Havlin <jhavlin@netbeans.org>
Log: #144504: Display number of records displayed in SQL History window

Patch by Matthias42.