VS Code "Database Projects" tab not ordered

[codykonior]

Whenever you open the "Database Projects" tab (sidebar) in VS Code, the projects are loaded in a random order. If you have a dozen projects like I do, and hit the refresh button, they'll be reloaded in a random order each time, which makes it hard to find anything.

Please order them alphabetically. This would greatly aid usability.

[ssreerama]

Hi @codykonior ,

I have observed that the projects are loading according to the order in which they were opened/created. For instance, if I add a few projects in the order 2 -> 4 -> 1 -> 3 -> 5, upon reloading the extension or refreshing the projects pane, the projects reload in the same order. If a project is added under an existing project, such as project 6 being created under project 4, it will be nested under its parent folder 4, resulting in the order 2 -> 4 -> 6 -> 1 -> 3 -> 5. I do not observe any random changes in the order upon each refresh or reload.

Could you please provide the exact steps you are following to reproduce this issue? Thank you.

[dzsquared]

projectsresorting.zip

sample for repro attached - I open a folder in VS Code, then create 3 sql projects in the folder (projectA, projectB, projectC).
now just about every time I click the refresh button on the view (or anytime a change causes the view to refresh) the project order shuffles.