New code assistant feature (filter method = Contains) shows too much, when name is partly given

[Claus Pedersen]

I have the sql

SELECT * FROM user_tab_columns WHERE user_tab_columns.us

and press F6 to activate code assistant.
The list shows all column names containing "us", i.e. "char_used" and "user_stats", but when code assistant is activated when the user have types letters after the dot, only entries beginning with the letters in the code should be displayed, i.e. "user_stats" or as a minimum be displayed at the top of the list as first choice.

If I e.g. type "SELECT * FROM col" and press F6, only objects starting with "col" are shown (like "cols" and "column_privileges" and not e.g. "user_tab_COLumns" or "user_COL_comments". Pressing F6 after "user_tab_columns.us" should behave the same way.

 

[Marco Kalter]

We're looking into displaying the the items that start with the filter text at the top.

 

[Claus Pedersen]

Super, thanks

 

[Claus Pedersen]

From the beta 6 'release note':

If the Code Assistant Filter Method preference is "Contains", items that start with the filter text are now placed at the top

It works much more intuitive now. Thanks to the developers.

One thing should be corrected, though. If I begin typing the select

SELECT user_tables.ta

and press F6, the following list of column names is shown:

• table_name
• tablespace_name
• table_lock
• (all)
• status
• instances
• ...

Note that row no. 2 (tablespace_name) is highlighted and the entry for (all) is shown below the matching column names.
I believe the reason for row 2 is highlighted is that in version 12, (all) was always row no. 1 and the first 'real' row name was therefore always no. 2.

I think that (all) should still always be on top, and then it is OK that row no. 2 is initially marked. If (all) should be sorted after the column names with exact match, then row no. 1 should be initially marked.

When showing the code assistant pop-up list after having written a part of a object name like "SELECT * from user_tab" and then press F6, the list of matching object names is highlighted on row one and I can press Enter or navigate to another row.

When I write "SELECT user_tab_columns." and press F6, nothing is highlighted in the list. If I press Enter, nothing is selected (and the Enter is just entered in my code). I have to press e.g. Down-Arrow to give focus to the list and highlight the first row, so it can be selected by pressing Enter.

Please always highlight the first row in this list as well.

 

[Marco Kalter]

We'll enhance this

 

[Claus Pedersen]

Thanks

 

[vlevi]

I have noticed in the beta 5, that code assistant column filter jumps to the 2nd field in the list.
This is becasue, the (all) is the first item in the list, but when I start to enter the field names, the first field name is a real field name, mostly the field name what I need, but the code assistant highlights the second row of the field list.
I have to select the previous field, which is not a handy feature for an assistant...

 

[Marco Kalter]

This was indeed not correct, and has been fixed.

 

[Claus Pedersen]

Beta 7, the (all) issue is solved. Thanks to the developers.

Still, when I type "SELECT user_tab_columns." and press F6, the list of column names does not seem to have focus. First when I press Down-Arrow or similar, a row is highlighted.

Please highlight e.g. the first column name (second row), so it can be selected just by pressing Enter.