Feature Request - Vertical Query Results
Answered
Just wondering if it would be possible to view the results of multiple queries in a vertical fashion (like in SSMS) instead of in separate tabs. This is incredibly useful when running ad hoc queries / analyses on multiple tables, to get a quick glance, etc.
If vertical query results aren't possible, perhaps it'd be possible to split the query results vertically?
Let me know if any of this doesn't make sense or if it's already available.
Thanks,
Josh Mann
Please sign in to leave a comment.
It is possible for a single Database tool window: you can drag results tab:
But it is not yet possible to see output from different databases (related request is https://youtrack.jetbrains.com/issue/DBE-1231 ).
Thanks Andrey Dernov
I also vote for this feature.
You can drag the result tabs, yes, but that's not what the OP and I want.
If you use SSMS you will see a list of results in vertical, like this:
It is much easier to navigate than Intellij Result tabs, don't you think?
It seems this is covered by View as -> Tree (and then expand), noted here: https://www.jetbrains.com/help/datagrip/tables-view-data.html#data_view_modes
Although, yet again I think Ngxtri is looking for something different again as the examples are horizontal?
Hope this helps someone coming from workbench to datagrip
@Martin
Related feature requests to upvote:
In the meantime, you can use the "In-editor Results" mode:
Martin,
As Josh and Andrey said: `results of multiple queries`
Those multiple queries could be a mixture of SELECT, UPDATE, EXEC, etc...
Those SELECT can have JOIN, SUM, etc... within them; so sometimes Data Editor -> Tree mode doesn't work.
As you can see in Andrey's example; he uses GROUP BY; which is not supported in Data Editor
Arina Efremova in-editor results can be useful; but having to run each and every line of select statement is not very productive. We normally execute a bunch of queries in one batch; and view results in tabs. If you haven' done so, please look at SSMS or Oracle SQL Developer to get a feel of it.
Thanks all.
Brian (ngxtri)