Problems Regarding Scripted JQL Functions

Hi there,

We use Script Runner v2.1.15 and JIRA Agile 6.6.0, we encountered an issue:

We created a Kanban Board, which its filter query was:

project = "Test Project" AND issueFunction in dateCompare("", "resolutionDate > dueDate")

We found the Kanban could not be opened normally with an error “Request Time Out”(see screenshot “error.png”).

Could you help to find the reason for the issue? Thanks!

error.png

1 answer

I'm not sure what exactly the problem is, but you need to write this query as:

issueFunction in dateCompare('project = "Test Project"', "resolutionDate > dueDate")

There is no optimiser in JQL unfortunately. The way you have written it, the search engine will get the issues for Test Project, then run the dateCompare function over all issues in your database, then take results which have matches in both clauses.

So you should use the subquery option in dateCompare, it's what it's there for!

 

Hi Jamie, Thanks for your reply. Your solution works for us. Besides, we have another Kanban board, which its filter query is: project = "Test Project" And we set a quick filter for this board, and the quick filter JQL is: issueFunction in dateCompare("", "resolutionDate > dueDate") When we click the quick filter, the error(“Request Time Out”) mentioned above still persists. Do you have any good ideas about it?

You need to change the quick filter jql to what I told you. The quick filter doesn't filter just in the subset of issues returned by the board filter, afaik.

Hi Jamie, we changed the quick filter but it didn't work. Our board filter original JQL was: project = Test Project AND (status != Closed OR status = Closed AND updatedDate >= -1w) AND assignee in membersOf("group1") Our quick filter original JQL was: issueFunction in dateCompare("", "resolutionDate > dueDate") And then we changed the quick filter as your advice, so the quick filter JQL was changed to the following below: issueFunction in dateCompare("project = Test Project AND (status != Closed OR status = Closed AND updatedDate >= -1w) AND assignee in membersOf("group1")", "resolutionDate > dueDate") But this quick filter could not be saved in success. As our board had several quick filters, could you provide some workaround or what else can we do to resolve the issue? Thanks,

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Oct 31, 2018 in Marketplace Apps

Marketplace Spotlight: Zephyr

Hello Atlassian Community! Each month, we run a series of Spotlights to highlight Marketplace vendors and apps that our team thinks this Community would find valuable. In last month's Spotlig...

335 views 0 1
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you