[IMPROVEMENT] Add sorting in Kanban view at least for priorities

[pvi-github]

Is your feature request related to a problem? Please describe.

When displaying Kanban with a url like this : wwww/showKanban?search=true&projectId=8&sprint=all&type=story&groupBy=priority

The result is that priorities are listed in alpha order like this :

Alas such order puts low and lowest above medium, not speaking of unpriorized put at the end while it might be of the utmost importance.

Describe the solution you'd like
I suggest that we add a sorting capacity to function :

        /**
         * @param $searchCriteria
         * @return array
         * @throws BindingResolutionException
         */
        public function getAllGrouped($searchCriteria): array

in app/Domain/Tickets/Services/Tickets.php

And a default sorting order in function

        /**
         * @return array
         */
        public function getGroupByFieldOptions(): array

We might have to add a table with priorities with sorting order, id and label if we want to make things neat.

And this could be used more largely than just priorities.

In due end adding the possibility to define sorting options in user interface would be ideal. But this can be done in an other time.

What do you think ?

PVI

Additional context

Nothing more.

[pvi-github]

After a check i'd suspect that this issue is linked to #1715 : the sorting of priorities seem common to all view modes (Kaban, list, table).

So working on this sorting of priorities might bring good in all view modes.

[pvi-github]

And by the way adding a table with priorities as suggested might also help to deal with #1199 => Adding the ability to edit the table would be rather simple but if we want to let project managers customize priorities by project we would need to add a column with project id.

[marcelfolaron]

Totally agree. We need a sorting option. There are a couple places where this will have downstream effects. I would like to "htmx-fiy" the page first so that all of that can happen asynchronously.