How to filter tickets in JIRA with the criteria written in below description field ?

[Vinit Chaware]

We have almost 20 projects in JIRA. I want to search below things.

What projects have tickets coming in that are not being addressed ? Addressed meaning : which have no actions from the time they got created.

Who is / are the main person / people addressing tickets within each project - not the project "owner" necessarily

[Mohamed Benziane]

Hi @Vinit Chaware 

To know if an issue was not updated you can use this :

NOT updated > -10d 

This query will find all issue that haven't been updated in last 10 days, but you'll even get issue created one year ago and not updated. So you need to add some criteria in your query like status or created date.

createdDate >= startOfWeek() and NOT updated > -1d

 For the second question , you mean the assignee ? The one you will work on the issue ?

[Vinit Chaware]

Hi @Mohamed Benziane ,

Thanks for the suggestion. I am checking on the same.

About my second question. In other words we can say I want to search top performer in each project who is acknowledging and working on maximum tickets.

[Jason Rogers]

You could do a JQL search for all issues created in a certain amount of time (7 days for example) and then see if they have been updated. 

created >= -7d AND updated is EMPTY

This should show all issues that have been created, across all projects, that have had no updates since. Then you can change the columns of the filtered results to show the reporter - which will tell you who created the issue. The project key will indicate what project they are coming from. 

[Vinit Chaware]

Hi @Jason Rogers ,

Thanks for replying to my query.

I am checking on the same. Will get back to for more suggestions.