microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 898 forks source link

API access to dashboard explorer widget #8913

Open dzsquared opened 4 years ago

dzsquared commented 4 years ago

Is your feature request related to a problem? Please describe. Extension developers are able to add context menu items to object explorer nodes, but this contribution point only impacts the side bar object explorer. When users interact with object explorer from the dashboard widget (server and database), all the custom options are missing.

Describe the solution or feature you'd like Either the dashboard widget object explorer to inherit object explorer context menu options or a separate contribution point for the dashboard widget.

Describe alternatives you've considered Creating a webview for extension functionality that integrates tightly with object explorer seems to be the other option at the moment and quite a bit of overkill.

alanrenmsft commented 4 years ago

@dzsquared , thanks for submitting the issue, we would like to know more about your requirements, please share your scenario with us and we will review it.

dzsquared commented 4 years ago

The object explorer enables the addition of context menu items: image

The dashboard (object) explorer widget is searchable and can be accompanied by other useful widgets on the dashboard. image

For example, I have a context menu item to run a script against a particular table (such as sp_BlitzIndex). When I'm working in a database with a lot of tables and it will take quite a bit of scrolling to find the table I'm looking for in the object explorer. The searchable interface of the widget makes it much faster to find the table I'm looking for - except the menu item to execute the script is missing.

alanrenmsft commented 4 years ago

I see, I looked at your package.json and you are contributing menu items for object explorer, I think it makes sense to add those menu items to the search widget for the matching objects as well. sounds good to you? @dzsquared

dzsquared commented 4 years ago

@alanrenmsft it would be great if the contributed menu items for object explorer automatically populated to the search widget, that would help users seamlessly switch between the OE and the dashboards. thank you!!

dzsquared commented 3 years ago

Just ran into this issue again when using dacpac wizard with an Azure SQL DB server. I had connected to master which usually doesn't populate the list of databases in object explorer and the dacpac wizard isn't available in the context menu on the dashboard widget list of databases.

image

workaround was to launch the dacpac wizard from the context menu on the databases folder node in OE