JQL query to find same summary value issue?

Chaya Reddy nagella March 6, 2013

How to find issue with same summary value ?Any plugin is available or JQL query?

Thank you

4 answers

1 accepted

0 votes
Answer accepted
codelab expert
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2013

No, such JQL doesn't exist. The only way to examine all same summary values is to export all issues (only fields issuekey and summary) to excel and summarize in excel.

Chaya Reddy nagella March 7, 2013

Mathias,

Thanks for your answer. But we have 4000 > issues in a single project and almost 1000> in another 5 projects. Daily we get 20- 30 issues in a project.

May be it might cause performnace issues to export and import them again..??

Teck-En
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 9, 2013

It would depends how many issues you export at a time as exporting too many issues at a time would resulted in huge memory consumption and would cause outofmemory error.

JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 10, 2013

Why don't you just do it in the database... count (*), summary, group by summary having count(*) > 1.

1 vote
Teck-En
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 9, 2013

Perhaps using jql such as:

assignee in membersOf("jira-developers")

0 votes
Chaya Reddy nagella March 7, 2013

I need to search for all issues and limited to only Administrators.

Appreciate your help...

Chaya

0 votes
Henning Tietgens
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2013

Do you search all issues which have the same summary as one selected issue or do you want to have a duplicate search over all (or over the result of a jql search)?

Has this search to be available for "nornal" users or a administrators enough?

Henning

Suggest an answer

Log in or Sign up to answer