#337 - JQL for worklogs fails with large project

s4nf4n commented on Jan 09, 2024

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

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.

Windows

Bug Description

I am sorry, but I am not entirely sure if this should better be an enhancement. But e.g. Worklog Calendar is not working for me.

The Jira Cloud instance contains a very large project. And the JQL used for fetching worklogs fails with Internal Server Error 500. JQL used for Worklog Calendar looks like worklogAuthor in (currentUser()) and worklogDate >= '2023-10-08' and worklogDate < '2023-10-17'.

When using the query console in Jira itself it results in the same error. But it is quite easy to compensate for this by adding AND project!=VERYLARGEPROJECT.

Please add functionality to customize worklog JQL.

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)

srtucker commented on Dec 01, 2023

I have this issue as well and have been working with Atlassian cloud support for about a month on the same issue. The problem is that the queries times out. They did say that they add some additional indexing to the tables to make it work better but it seems to be hit or miss. I have found that adding ORDER BY updatedDate DESC to the JQL makes the query much faster. It would be great is there was a setting to add additional JQL to the query that the calendar feature uses.

shridhar-tl commented on Dec 21, 2023

@s4nf4n - Are you still facing this issue or it got resolved by itself?

s4nf4n commented on Jan 08, 2024

@shridhar-tl Yes still having this issue. Thanks for implementing this. Hope to see this released soon!

s4nf4n commented on Jan 09, 2024

@shridhar-tl Webversion is working! Thanks alot.