Is there any filter for getting the defect if it has only one label. (A defect may have multiple labels in our case)

[Pablo Beltran]

SQL for JIRA does the job in a straightforward way.

Simply convert you JQL;

type=defect

into a SQL and filter by the amount of labels:

select i.key from issues i inner join issuelabels l on l.issueid = i.id where JQL = 'type=defect' group by i.key having count(*) = 1

then convert back the SQL into a JQL:

issue in sql("select i.key from issues i inner join issuelabels l on l.issueid = i.id where JQL = 'type=defect' group by i.key having count(*) = 1")

[Kamal]

Hi Steven,

Thanks for the reply.

So, if i have 50 labels. Then i need to give all those in the NOT . 

[Steven F Behnke]

No, not out of the box. The best you could do is something explicit – 

label = triage AND label not in (branch, computer, upset)