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 144506 - [65cat] Display Previously Used Matching SQL values in SQL History
Summary: [65cat] Display Previously Used Matching SQL values in SQL History
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks: 152828
  Show dependency tree
 
Reported: 2008-08-20 01:23 UTC by adam_myatt
Modified: 2014-10-05 12:38 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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

First, great job on the Matching SQL filter feature in the SQL
History!! So far good performance with it. 

In the SQL History window, I suggest making the Matching SQL filter
feature cached so that it displays previously searched values in a
dropdown so that each day you can re-filter on filter values you used
on prior occassions.
Comment 1 Jiri Rechtacek 2009-10-16 14:10:22 UTC 
Reassigned to new owner.
Comment 2 matthias42 2014-10-05 12:38:33 UTC 
I had a look at this and I'm not sure whether I find this a good idea - it comes down to having two histories/lists (real history + history of searches).

Basic problem: When is a search added to the search-history and how long to make that history.

For when: Adding the entry after it was unchanged for X seconds is an option
For how-long: Big question 10-20 entries should work for combo-box, but 10-20 searches are quickly done and the list "reset"

At this stage I'm reluctant to implement this, as I doubt the benefit.