Three solutions in one Jira project

[David Kon]

Our organisation uses Jira Enterprise and I was assigned a project, managed by the Corp.

Our team develops three different solutions, name them:

• Solution A
• Solution B
• Solution C

I created three different Boards each one for one solution.

In the query for each board, I set a query looking for a component with the solution's name, for example:

project = MyProject and component = "Solution A"

This way, whenever one of the developers opens a new issue and sets the component as his solution, the issue appears in the right board.

My problem is, whenever I open a new issue and the "Component" field is not present, then the issue won't appear in the right board, and you have to find the issue and set the component.

Is there a better way to do this?

Thanks!

[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)