how to find issues with multiple subtasks

[Damian Kiesling]

I'm looking to write a query that will allow me to find all issues that have more than one subtask of the same type. Most of our issues always have 2 subtasks (type 1 and type 2). Occasionally, something will get messed up and somebody will create 2 type 1 subtasks. I'm looking to find all of those with multiple type 1 subtasks so i can clean them up.

Thanks.

[Jobin Kuruvilla [Adaptavist]]

You can't do this by default in JIRA. A plugin like JQL Tricks will help you find issues with a specific subtask type and will help you search based on the count of subtasks. Maybe you can try that.