Start Work: Update Jira issue search request to sort by update date

[sergeibbb]

This issue is a follow-up of #3621

The problem

For Jira, on the Start Work view I'm only seeing issues that I created/authored. It should show, and prioritize, issues I am assignee on, like this one for example. Instead I am seeing issues I reported even if they have no assignee.

The explanation

The mentioned issue probably is in the search result, because the current search query is:

(creator = currentUser() OR assignee = currentUser() OR comment ~ currentUser() OR summary ~ currentUser() OR description ~ currentUser())

but in the current order it doesn't appear on the first page, that's why the user doesn't see it.

The solution proposal of the solution

https://github.com/gitkraken/provider-apis-package-js/pull/194

Require issues to be ordered by update date. So the user will the recently updated items first and most likely see the issues they are interested in. Stale items will be at the bottom of the list or cut out by the query limit.

Add the following suffix to the query:

ORDER BY updated DESC

This solution is questionable, it has its advantages and disadvantages.

Advantages:

• it's easy to do
  Disadvantages:
• "The most recently updated issues where the user has been involved" is not the same as "the issues the user is most involved in". Probably a better solution would be somehow to order by a date of the most recent change related to the user. But there isn't a way to achieve it in JQL.