Azuredatastudio: Feature Request: Filter in "object explorer"

[sroyvs]

Like in SSMS have the ability to apply a filter/search in the object explorer, to find tables/SPs or functions

[luiznovaesneto]

Unfortunately doesn't have the filter feature in the object explorer yet. However, you can display the explorer-widget and use it to search the objects. It is really usefull because allow you to search many kinds of objects like tables, views and Stored Procedures.

[jakodev]

It is one of my favorite features in ssms, I will really appreciate it

[sgf]

Filter Table Name, Colume Name, Procedure Name....
its very important feature

[qwefgh90]

Filter or other features which provide same usability like SSMS would be necessary.

[pietie]

Please consider making this an inline filter. So just a simple input box at the top of Object Explorer that I can type stuff into. I have always found the dialog in SSMS a pain to work with. Especially if you need to do a bunch of quick searches one after the other.

And it should be smart. So if I type dbo.MySproc it knows to break it up into schema and routine name. You can go even further and allow expressions (think Wireshark) .. e.g. schema != 'dbo' AND name like '%abc%' AND type='proc' to filter on all sprocs that have a name containing 'abc' that are not in the dbo schema.

[elonmallin]

Yes, would be really nice to have a smart search box instead of the old way of doing things in SSMS.

There are a lot of issues open about searching/filtering now. Seems like a lot of people would really appreciate such a feature.

[wsmelton]

This ability has been in VS Code Insiders for some time but it is for file view, not sure how you could port it over to the server explorer window....

https://twitter.com/wsmelton/status/1090017132757295106

[KamasamaK]

@wsmelton This was deployed to stable in VS Code 1.31 and is actually part of the new tree widget which is not exclusive to the workspace file view. For example, the Outline and Breadcrumbs trees are also using the new widget and it should be usable for any existing tree.

[wsmelton]

The server explorer doesn't support filtering object list by typing like the file list does.

[KamasamaK]

@wsmelton Yes, that is clear. I was making a clarification that the feature you mentioned is not exclusive to Insiders and is not specific to the workspace file view, but is a new tree widget that should be able to be used for an existing tree like the Servers view and is already merged from the vscode master.

[KamasamaK]

Starting with VS Code v1.37, all trees have the highlight and filter capability.

[bbeda]

I would definetely want this feature as well. I am sometimes going to SSMS just because I want to have better filtering.
Also, maybe I am missing something here but is there a way to resize the Search pane? Most of the time our names are longer than the pane and what I am searching for has multiple matches. I have to hover over each one of those to select what I am looking for.
Thank you

[Charles-Gagnon]

Closing this as a duplicate of https://github.com/microsoft/azuredatastudio/issues/8052 as cleanup