No an issue, perhaps a suggestion, if possible

Question

No an issue, perhaps a suggestion, if possible

BogdanBigB opened this issue 7 years ago · 9 comments

Hi again.

We are implementing a "curious" DB structure.
i.e. Shemas and Tables like
[Current.Alert].[Alert]
[Current.System].[AlertStatus]
[Current.System].[AlertType]
etc.

It would be nice if the tree can go like this:
-Current
-Curent.Alert
-Current.Alert.Alert
-Current.System
-Current.System.AlertStatus
-Current.System.AlertType

This is how the extension actually displays this scenario:

Answer 1 · 2017-12-01T06:08:19.000Z

My text in the previous comment was altered. I meant, if the tree could look like this:

Answer 2 · 2017-12-01T06:24:16.000Z

I've been thinking about adding additional folder levels using a user defined regular expression. That way it can have folders for stored procedures based on the naming convention used, e.g. when it sees the first underscore. I will keep your structure in mind when I start to develop this.

Answer 3 · 2017-12-01T06:30:49.000Z

Great, thanks a lot. I'll keep an eye for updates 👍

Answer 4 · 2018-04-13T12:43:07.000Z

If we could write our own expressions like
substring(name,1, charindex('_',name,charindex('_',name,1)+1))
it would be great.
We use several "_" in our naming convention, and have lot of tables.

If it also would be possible to define a list of database.schemas an expression should apply, it would be great.

Answer 5 · 2022-06-23T13:19:03.000Z

Hey @nicholas-ross,

The issue might be a little old but do you have an update on this, because I' m very interested in this feature?

Thanks for this awesome piece of software it makes SSMS so much cleaner.

Answer 6 · 2022-06-24T00:53:53.000Z

I did experiment with this at the time. There is a branch called FolderLevels that added a second folder level and sorting by first letter. I never got to implementing the custom sort. Between work, life and changing to a new computer, it got left behind. It has been on my mind for the next version but I cannot give you any time frame for when that would be.

Answer 7 · 2022-06-24T06:40:20.000Z

Hey nicholas,

thanks for your response.
It's already wonderful to hear that you experimented with possibly adding the feature.
I will be looking forward to the next version of your plugin:)

kind regards.

Answer 8 · 2022-08-04T07:04:36.000Z

See release v1.4-beta2.

Answer 9 · 2024-04-12T07:05:52.000Z

v1.5 added support for a second schema using a dot. v1.6 added underscore as an alternate delimiter. Pattern matching will come at a later date.