Can someone provide me with some help creating a search with specific criteria

Toby Challacombe August 3, 2018

I would like a queue that display all tickets not updated (Had a comment) on the current date, so all tickets that have not been updated since at least yesterday or before. 

1 answer

1 accepted

2 votes
Answer accepted
Tansu Akdeniz
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 3, 2018

Hi @Toby Challacombe,

Finds issues not updated for 2 days;

  • updated < -2d

If you have Script Runner, you can find issues commented but status was not changed;

  • issueFunction in commented("after -1d") and not status changed AFTER -1d

 Also it can be useful for service desk to see the issues last commented by customer;

  • issueFunction in lastComment("inRole 'Service Desk Customers'")

Detailed JQL doc: https://confluence.atlassian.com/jiracorecloud/advanced-searching-fields-reference-765593716.html

Script Runner functions doc: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

Toby Challacombe August 3, 2018

That is perfect thank you, I did take a look through the JQL doc but could not find exactly what I needed. Much appreciated!

Suggest an answer

Log in or Sign up to answer