search

microsoft / vscode-mssql

Visual Studio Code SQL Server extension.
Other
1.54k stars 459 forks source link

Allow filtering of objects in Object Explorer #1445

Closed adisoftware closed 1 month ago

adisoftware commented 5 years ago

This is something I've wanted in SSMS for years. The Object Explorer can become a huge list. I'd like a search field which does wildcard filtering on items in the object explorer.

So keep the structure (e.g. server > Database > Database Name > Tables) etc, but filter the end nodes, the actual tables/sprocs etc, based on the filter.

Msjronkko commented 4 years ago

This would be a great enhancement! Maybe it could work similar to the way SSMS does filtering?

ssms-filter
adisoftware commented 4 years ago

I actually really dislike the SSMS way - I think it's too cumbersome and time consuming to use so I end up just searching manually for the item most of the time. That's why I'd like a simple text box that dynamically filters as I type - like a lot of Ajax lookup boxes on the internet. To me, that's the most elegant way of doing it (although I guess an advanced filter like the SSMS one is a nice thing to have in addition - but I wouldn't use it).

Msjronkko commented 4 years ago

I totally agree that for single table lookups a search field would be the most elegant way. However in cases where where we have multiple data sources that are divided into their own schemas (A.table1, A.table2, B.table1) and I'm working with just the A-data, ability to filter out all else than A based on for instance schema name, would be great.

ceka commented 4 years ago

is it possible to view objects by schema and then by object type?

toferj commented 4 years ago

@abist What does the "upstream" label mean? I'm really excited for this feature though I'm sure there are other more important features ahead of it. Even just being able to filter by schema would help me. If I even knew where to start looking at the code for this, I'd have a crack at it (no promises). I don't know what kind of committee or whatever features like this go through to determine how they'll look, function and will be implemented.

Anyway, would love to see this feature get more attention by the community... or are there really only four of us who want this feature. ;)

Thanks!

p-clements commented 3 years ago

I’d like to throw my hat in and say this functionality would be very useful. Our DBs have many tables and SPs so having an ability to quickly search and fuzzy search across all objects would save literally hours.

aasimkhan30 commented 1 month ago

Closing as this feature is already in main and will be released in the next version.