We have kicked up a project to clean-up a legacy project in JIRA. With 3000+ open items we need the ability to filter out JIRA issues using the following additional criteria: * Number of comments. e.g. issues with 5+ comments * Last comment date. e.g. Last comment in the last 3 years. If this can be achieved via Database queries, I appreciate more details on how to achieve this?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Advanced filter using number of comments and date of last comment

Bashar Ayoub

We have kicked up a project to clean-up a legacy project in JIRA.

With 3000+ open items we need the ability to filter out JIRA issues using the following additional criteria:

Number of comments. e.g. issues with 5+ comments
Last comment date. e.g. Last comment in the last 3 years.

If this can be achieved via Database queries, I appreciate more details on how to achieve this?

Accepted answers

Derek Fields _RightStar_

Scriptrunner has a function called hasComments that takes a number expression (e.g., 3, +5, -10) and returns issues that match the number expression. It also has a lastComment function that will let you specify the date of the lastComment to return.

You can find scriptrunner in the marketplace

All comments

Hernan Halabi - Elite IT Consulting Group

Hello @Bashar Ayoub welcome to the community, depending on the version you have just by seeing the projects list you should have the last time it got updated each project. That should help you easily identify the main candidates.

If your version is too old you can't see that there and you will have to go to the database and run the queries there to get the information you are looking for.

As far as I know, you can't get that information using jql only

Bashar Ayoub

Version number is JIRA v7.1.4.

I have access to last updated date. However I am after filtering by number of comments and last comment date.

e.g. List all items created before 2010 and last comment added before 2015.

List all items created between 2010 and 2015 and last comment added before 2018.

Hernan Halabi - Elite IT Consulting Group

Then it's going to be via database queries. We used to have those queries but for older versions and I'm not qualified to help you create a new one. Hopefully someone else in the community can better help with that part.

Optionally check for apps like this one

https://marketplace.atlassian.com/apps/1220583/simple-last-comment-for-jira?hosting=server&tab=overview

Those might help as well.

Derek Fields _RightStar_

You can find scriptrunner in the marketplace

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server