Request: new code completion filter enhancement must put entries with exact match on top of list

[Claus Pedersen]

I like the new code completion filter enhancement very much.

I have a request, though. Why not combine the best of both worlds with "Contains" and "Starts with"?

I use "Contains" and if I type

SELECT * FROM all_tables t WHERE t.in

and code completion pops up, I get the list:

• ini_trans
• initial_extent
• min_extents
• pct_increase
• logging
• chain_cnt
• instances
• monitoring

I would suggest that the order by is changed so lines with exact match (beginning with "in") is put on top of the list, so the list would be like this:

• ini_trans
• initial_extent
• instances
• min_extents
• pct_increase
• logging
• chain_cnt
• monitoring

Note that "instances" is now grouped together with the other column names starting with "in". In this way it is quicker for the user to locate "instances" (which in this case could be the column name, I was looking for).

Or if I type

SELECT * FROM all_tables t WHERE t.se

then the column names "secondary" and "segment_created" would be grouped together in the top of the code completion list.

With the current sorting, I would have to press the Down-Arrow key 6 times to get to "instances", whereas with the new proposed sorting, I would only have to press Down-Arrow 2 times. Also, it would be easier lo locate visually.

Maybe put this in an new option in the preferences together with "Contains" and "Start with": "Contains, starts with sorted on top"

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Claus Pedersen]

Thanks. Would make a great feature even greater