JQL query to find same summary value issue?

[Chaya Reddy nagella]

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

Thank you

[codelab expert · Accepted solution]

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]

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]

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]

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

[Teck-En]

Perhaps using jql such as:

assignee in membersOf("jira-developers")

[Chaya Reddy nagella]

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

Appreciate your help...

Chaya

[Henning Tietgens]

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