No an issue, perhaps a suggestion, if possible

[BogdanBigB]

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:

[BogdanBigB]

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

[nicholas-ross]

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.

[BogdanBigB]

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

[SG12345678]

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.

[Icecoldmeat]

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.

[nicholas-ross]

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.

[Icecoldmeat]

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.

[nicholas-ross]

See release v1.4-beta2.

[nicholas-ross]

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.