#110 Auto-complete(intelli-sense) SQL in editor

2013.08
closed
Anu
evol (19)
2013-08-07
2013-03-30
Anu
No

Support suggestions and auto complete in Command/Syntax editor of SQL syntax while typing.

DONE
1. Added "Auto complete" checkbox in Tools>Preferences>CommandEditor to enable/disable this feature.
2. On typing suggestions on Table names are displayed only for entered text more than length 2.
3. Key bindings - Up,down to select the suggestion and Enter for insertion.
4. Columns are proposed only after entering table name with a dot. (Like user.)
5. Feature supported in client command editor and query designer syntax editor.

Example syntax, note that for column proposals table name is
select * from user where user.name = 'test'

TODO https://sourceforge.net/p/sqleo/tickets/130/
- Suggest on alias (useful in join queries) (Like SQLDeveloper for more details)

Discussion

  • PAscal
    PAscal
    2013-06-04

    • status: accepted --> open
     
  • PAscal
    PAscal
    2013-06-12

    • Milestone: next release --> not planned
     
  • PAscal
    PAscal
    2013-07-10

    • assigned_to: Anu
     
  • PAscal
    PAscal
    2013-07-12

    • status: open --> accepted
     
  • Anu
    Anu
    2013-08-06

    • Milestone: not planned --> next release
     
  • Anu
    Anu
    2013-08-06

    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,7 +1,16 @@
     Support suggestions and auto complete in Command/Syntax editor of SQL syntax while typing.
    -Add "Auto complete" checkbox in Tools>Preferences>CommandEditor to enable/disable this feature.
    
    -1. Auto complete while typing by displaying all suggestions on Table+column names.
    -2. Also suggest on alias (useful in join queries) 
    -(Check SQLDeveloper for more details)
    +DONE
    +1. Added "Auto complete" checkbox in Tools>Preferences>CommandEditor to enable/disable this feature.
    +2. On typing suggestions on Table names are displayed only for entered text more than length 2.
    +3. Key bindings - Up,down to select the suggestion and Enter for insertion.
    +4. Columns are proposed only after entering table name with a dot. (Like user.)
    +5. Feature supported in client command editor and query designer syntax editor.
    
    +Example syntax, note that for column proposals table name is 
    +select * from user where user.name = 'test'
    +
    +TODO later
    +- Suggest on alias (useful in join queries) (Like SQLDeveloper for more details)
    +
    +
    
     
  • Anu
    Anu
    2013-08-06

    • status: accepted --> closed
     
  • PAscal
    PAscal
    2013-08-06

    • Milestone: next release --> 2013.08
     
  • Anu
    Anu
    2013-08-07

    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -10,7 +10,7 @@
     Example syntax, note that for column proposals table name is 
     select * from user where user.name = 'test'
    
    -TODO later
    +TODO https://sourceforge.net/p/sqleo/tickets/130/
     - Suggest on alias (useful in join queries) (Like SQLDeveloper for more details)
    
    • assigned_to: Anu --> nobody
     
  • Anu
    Anu
    2013-08-07

    • assigned_to: Anu