Feature Request: Favorites Modal: Tagging & Sorting

[mkormendy]

Note: Resize of rename column has been moved to #765.

I was attempting to edit the name of my favorite queries that I saved but the list of favorites in the modal seems to have a fixed width and I couldn't see the full names of all of my favorites in that list. It was difficult to follow a naming structure since I couldn't see past ~24 characters in that column.

The reason why some of the names of my favorite queries were so long is because I have to append a prefix to define which ones are MSSQL vs MySQL vs ... (you get the idea). Currently I just use a two character prefix, but maybe a better option would be to allow us to tag the queries and a little round circle that we could define is associated with whatever tag name we wanted (or if you want to associate it with your defined tag colors for either DB platform).

Lastly, it would also be super helpful if the favorites list could be chosen to be sortable by either by ASC/DESC alphabetical and/or user customizable drag and drop order. The choice to have both options would be preferred.

I use the favorites quite often, and I have a set of common query structures that re-use and modify as needed throughout my day, this basic feature is invaluable to me and would help a little more if the above features would be added.

Thanks again for all your work on this.

[hankinsoft]

Thanks for the note on this. I'm hoping to get some of these favourite improvements into one of the next upcoming builds.

[hankinsoft]

Just wanted to note that as of the latest build, the favourites dialog is a bit larger and the favourite names can now be scrolled. I'm working on some additional improvements as well (moving favourites to the iCloud file system so they sync between systems is the first coming improvement, but more will be added afterwards).

[mkormendy]

That's great! Just being able to adjust the width of the favorites list in the popup window would be awesome.

[GaryMeyers1]

I am using version 2021.27 which is the latest version that comes down when I click on the Download button. It would be great if there was a splitter on the screen to resize the query names list. I don't need anything fancy like iCloud syncing, just a vertical splitter would be great. Please see the screen space that's available in the attached images.

[hankinsoft]

Separated this out into two issues.

1. Resizable names column. #765.
2. Tags & Sorting

[hankinsoft]

Resizing has been fixed for the latest builds (https://github.com/hankinsoft/SQLPro/issues/765). If you get the chance, please check and see if it works as expected.

[mkormendy]

Resizing is working as expected now. Thank you.

[hankinsoft]

What I've been thinking of doing is adding subfolders to the favourites, so that you can organize your favourites by folders. The question I would have, is how would they appear in the query editor. So if you had the following favourite structure:

• Folder 1
  • Favourite 1
• Folder 2
  • Favourite 2

And in the query editor you typed:

Favo

Would both favorites still appear for the autocomplete?

[mkormendy]

I've seen this feature before in other applications, and I think what you're planning will be a nice way to sort and organize things.

I think the direct parent folder of the favorite should be present in the output above each entry found.

As for the search UX, there are a couple more edge cases in addition to your suggestion that I would be planning for.

1. Can two entries have the same name but under different folders? (for example in different dev, staging, prod environment folders with same-named favorites and similar purposes for each environment)

If so, then I would suggest that the parent folders would need to visible as well in the search listing so the user could differentiate between the same-named favorites based on which parent folder they are in.

2. If by chance a user unexpectedly put two same-named favorites in the same folder (or left in root), how would one tell the difference between the two when searching?

--