Skip to content
← Customer Feedback for Devart

Settings and activity

318 results found

  1. DO NOT SHOW intellisense popup after "," typed and SHOW after ENTER pressed

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using the "Auto List Members" option in the settings and invoke the Completion List forcibly with the shortcut - by default, it's CTRL+Space.

    Best,

    Devart Support Team

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    When typing the column name in SELECT statements after entering the comma symbol the context-based prompt comes up (if after the FROM keyword the table name is provided). If you just want to enter the blank space you need to click the Space button. The context-based prompt just will keep coming up. If you press the Enter button the cursor moves to the new row and the context-based prompt disappears. If you just want the context-based prompt to be disappeared you have to click the Escape button. If you start entering first letter(s) of the column name the context-based prompt comes up with the relevant table names.
    Therefore, we don't count your request as the issue (bug). It's just by design.
    Note, using the Format Document feature you can customize formatting of queries.

  2. code completion not working when db is offline

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    Could you please clarify if it does not work only for offline databases or for each database on the server?

    A video or screenshots would be also of help.

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that metadata is retrieved from the database.

    If there's no connection, database object suggestions won't be displayed.

    Best,

    Devart Support Team

  3. SQL Complete does not support parsing SQL with valid PATINDEX function

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already fixed.

    Columns from tables in the SELECT statement are now being read correctly, including those used in PATINDEX('%text%', col_name).

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  4. Better intellisense for temp tables for DROP TABLE IF EXISTS

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    dbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that if you're using CREATE TABLE #TempTable in the same document,

    your temp table will be included in the DROP TABLE IF EXISTS statement on the first line.

    Best,

    Devart Support Team

  5. Remove debug stamp in Releases (keep it for your Debug versions only or verbose mode)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already fixed.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  6. Popup 'select top 100'

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    You could use the snippets functionality of dbForge SQL Complete.

    The snippet can be as follows:
    SELECT TOP $count$ *
    FROM $schema$.$table_name$

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemented in the interface.

    Adjust the displayed quantity in the options.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  7. Format declare statement with assignment from select statement eg DECLARE @sourceTrackId int = (SELECT Id FROM Track t WHERE t.TrackCod

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    Could you please send us the screenshots of the actual and expected results to our support system at supportATdevartDOTcom for investigation?

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that formatting subqueries can be configured in the settings.

    Best,

    Devart Support Team

  8. Order the results by a column A-Z, Z-A in Result Window

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemented.

    You can sort by clicking on the table header in the result grid.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  9. Extend Insert Highlight Occurences feature to show popup with column name in the values area

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that you can generate an insert template by right-clicking on the table name in the database tree and selecting "Generate Script As" option.

    Best,

    Devart Support Team

  10. It would be nice to be able to format the BY after GROUP and ORDER as a different line of code

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that there is a separate section for ORDER BY, GROUP BY clauses in both queries and subqueries in the formatting profile settings.

    Best,

    Devart Support Team

  11. Add column names to VALUES list for INSERT INTO statement generation

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that you can insert all columns when pressing Tab.

    Best,

    Devart Support Team

  12. Host SQL Snippets on some sharing site

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that you can share your snippets.

    And also you can find the path to the snippet files in the snippet manager under the "Location" field.

    Best,

    Devart Support Team

  13. Hide other databases from suggestions

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using the option "Do not load suggestions for the following databases."

    There's currently no option for ranking.

    Best,

    Devart Support Team

  14. Multi-select by selection of suggested objects

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Right now suggestions are adjusted based on previous joins.

    It's quite challenging to predict which tables you want to join, and new logic for constructing joins in the suggestions is required.

    Please be infromed that we have passed this feature request to our Product team for a review.

    A hight number of votes here would speed up the review and implementation process, so let's hope to get more votes.

    Once there is an update regarding implementation and release, you will be informed.

    Best,

    Devart Support Team

  15. Smarter subquery intellisense

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that fields from the main select are suggested in the subquery, so we would like to suggest using them.

    Best,

    Devart Support Team

  16. Move Forward/Backwards Through Tabs as Displayed

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest to look for Window.NextTab/Window.PreviousTab in the shortcuts.

    Just set up convenient shortcuts and use them.
    Best,

    Devart Support Team

  17. Sync edit in Highlight Occurences feature

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using refactoring for commonly used script objects, or find and replace in critical cases.

    Best,

    Devart Support Team

    AdminDevart (_, Devart) shared this idea  · 

  18. New Query Template

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your post!

    Could you please clarify why the snippets are not suitable for the template in the new tab?

    Best,

    Devart Support Team

  19. Toggle Comments

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    started  ·  2 comments  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi there,

    Thanks for your patience!

    Please be infromed that we are working on implementation of the feature.

    It will be included in to v.7.x

    Best,
    Devart Support Team

  20. Auto-filling the GROUP BY

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    planned  ·  1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your post!

    Please be infromed that we are working on implementation of the solution.

    The fix will be included in to v.7.x

    Best,

    Devart Support Team

1 2 3 4 6 8 … 15 16