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

Question

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

Vinit Chaware · Answer

Hi @Jason Rogers ,

Thanks for replying to my query.

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

Vinit Chaware · Answer

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.

Mohamed Benziane · Answer

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 ?