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

[janakiraman P]

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]

Hello @janakiraman P 

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

[janakiraman P]

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]

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