Worklog Calendar fails to load from Jira Cloud

[srtucker]

Checklist before you being

• I am sure that I am already using latest version of Jira Assistant
• I had verified that, no similar issues are already reported in issue tracker
• I had tried reproducing this issue with with Web version of Jira Assistant to ensure that this issue is not recently fixed and yet to be published
• I had verified that, my query is not answered in FAQ section of website
• I had verified that, my issue is not listed as known bugs in website

How do you use Jira Assistant?

Browser extension

Are you using cloud version of Jira or self hosted (data center / server) of Jira.

Cloud Jira

Version of Jira Assistant

v2.56 & WEB

What browser are you using?

Chrome

What OS are you using? You need not disclose this if you feel it is irr-relevant for your issue.

None

Bug Description

After migrating to Jira Cloud I have been having issues with the Worklog Calendar failing to fetch the worklogs. The API request returns a 500 error a little after 30 seconds. I have reproduced this on both the current version of the Chrome Extension as well as the web version.

I have been working with Atlassian cloud support for about a month and they said it is because the query is timing out. They did say that they add some additional indexing to the tables to make it work better but it still fails much more that it works.

I have found in testing that adding ORDER BY updatedDate DESC to the JQL makes the query return in under 200ms.

I pulled down the git repo and added ORDER BY updatedDate DESC to the following line and it is working wonderfully for me.

jira-assistant/src/services/worklog-service.js

Line 36 in a9864b3

const jql = `worklogAuthor in (${listForQuery}) and worklogDate >= '${mfromDate.clone().add(-1, 'days').format("YYYY-MM-DD")}' and worklogDate < '${mtoDate.clone().add(1, 'days').format("YYYY-MM-DD")}'`;

Would it be possible to make this change or add an additional advanced setting to add additional JQL to the query that the calendar feature uses?

Checklist before you submit

• I have ensured not to paste any confidential information like Jira url, Mail id, etc.
• I have verified my browser console logs and added necessary details (if required)
• I have added required screenshots if the bug is related to UI (as necessary)

[shridhar-tl]

Duplicate of #337.