Start Work: Update Jira issue search request to sort by update date #3740
Description
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.