Azuredatastudio: Filter in folders

[willmanrojas]

Issue Type: Feature Request

It does not have filters on the folders, since it is very complicated to look for functions, stored procedures, other objects, inside a folder, thanks.

Azure Data Studio version: azuredatastudio 1.2.4 (1ebfd0235690ad044ed2874a02e65188f5fea01c, 2018-11-02T21:50:52.634Z)
OS version: Windows_NT x64 10.0.17134

[beor]

I miss that feature too, that would be a great improvement on daily working and would make me change definitively to Operation Studio.

[philosophicles]

From #3761 by @jojeswe, which is a very close or exact dupe: "Folding/unfolding objects based on schema would also be nice." <--- I agree with this in addition to the original text of this feature request.

[philosophicles]

Just spitballing now but in my dream implementation of this, I'd want to be able to:

• Filter at the server node level, using name matching to limit what databases are visible under that node (sometimes servers have a LOT of DBs)
• Filter on a database node, matching any combination of schema names and/or object names, to limit what objects _of all types_ are visible within that database. I.e. this would affect visibility of all of: tables, views, synonyms, sprocs, and functions etc within that DB.
• Filter on one of the object type folders (Tables, Views, Synonyms etc), again on both schema and/or object name, to limit visibility within that folder (and any subfolders) only.
• Combine multiple filter condition strings with and, or, or not logic, on the same filtering target. For example, to show only Tables with name matching either %Sales% or %Returns%. Same for schemas.
• Use regular expressions in addition to SQL like-syntax wildcard searches.
• Choose, on-the-fly (even per-DB?), whether to nest folders under DB nodes like
  
  
  
  • Database --> Schema --> Object Type --> Objects
  
  
  • Database --> Object Type --> Schema --> Objects
  
  
  • Database --> Object Type --> Objects (with schema shown in name) <-- This is current behavior
  
  
• If a folder for Schema gets introduced because of this, then apply filters on that level too.

[A-damW]

In my opinion (especially for large/complex DB's), these are essential feature(s).

Another feature I would like to see, is the ability to apply a saved filter as a default.

[seanlmcgill]

A ReSharper-like Ctrl-T - universal search all the 'things' in the DB and display in an autocomplete filtered list, which then shortcuts you to the location in the 'Servers tree view' would be cool... but mostly yea, just need a filter of some sort in that main tree view.

[clansing-chr]

In my opinion (especially for large/complex DB's), these are essential feature(s).

Another feature I would like to see, is the ability to apply a saved filter as a default.

I agree. Unfortunately right now this is the only thing holding me back from switching from SSMS

[Charles-Gagnon]

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