JIRA query with Adaptavist ScriptRunner to identify all tickets which were not processed

[Alex Baumgartl]

Hi, I'm trying to find out if our JIRA reporting can be improved with ScriptRunner (which is installed as a demo version). I'm not a dev therefore I was not able to find a proper solution for this scenario:

I need all tickets

which were created from a member of a certain group in JIRA

and which were not updated after creation in any way (e. g. change of status from new to in progress) within a certain number of days.

I've managed to create a query which refers to today but this does not match to the query above:

issueFunction in expression("", "created +14*d > today") and reporter in (...)

I would be very happy for any help.

[Vasiliy Zverev · Accepted solution]

You can do this without scriptrunner. Here is JQL for your case:

creator in membersOf("jira-users") AND NOT status changed from new to "in progress"  AFTER startOfDay(-10d)

[Alex Baumgartl]

This works good for me, many thanks!

[vitaliy zapolskyy]

just curious why JQL

Updated = Created

is invalid?

[Vasiliy Zverev]

Unfortunatelly is is so. 

Here you can use dateCompare from ScroptRunner: https://jamieechlin.atlassian.net/wiki/pages/viewpage.action?pageId=57999378#ScriptedJQLFunctions-dateCompare(Subquery,datecomparisonexpression)