How to get the list of Issues with the same Summary?

Question

Hi,

We are developing a report which should find the duplicate summary (contains same summary in different tickets).
Are there any possibilities to achieve this using JQL?

Thanks in advance.

Nikola Perisic · Answer

Please refer to this page: https://community.atlassian.com/t5/Jira-Software-questions/Find-out-the-duplicate-summary-names-in-jira-cloud/qaq-p/1774689

janakiraman P · Answer

Hi @Nikola Perisic - Many thanks for your quick response.

I need a query to find all the duplicate summaries without providing the value like below.
summary ~ "<summary goes here>"

Kindly note: we can achieve this in MySQL with the following query
SELECT summary, COUNT(summary) 
FROM issues 
GROUP BY summary 
HAVING COUNT(summary) > 1;

Do we have any other option in built-in JQL to fetch the similar summary list?

Thanks.

Nikola Perisic · Answer

Hello @janakiraman P

Yes,you can use the query: summary ~ "<summary goes here>"