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

Question

Contact Kintosoft · Answer

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_l2skj7 · Answer

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 · Answer

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

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