Showing tickets from two projects on one board

[Ronnie Shorto]

I am trying to show tickets from two projects on one board (Project ABC in this case). The additional project's tickets that I want to show have a specific label assigned to them so not all of them are needed.

I am using this query which is not working as expected

project = "Project ABC" OR project = "Project DEF" AND labels = LableABC ORDER BY Rank ASC

If I remove the label then all of the tickets from Project DEF show so I am not sure if that is causing the issues. Any suggestions

[Sandesh Shetty · Accepted solution]

@Ronnie Shorto 

If you do not use parentheses, the statement will be evaluated left-to-right.  So you can

use 

project = "Project ABC" OR (project = "Project DEF" AND labels = LableABC) ORDER BY Rank ASC

[Ollie Guan · Accepted solution]

Hi @Ronnie Shorto ,

Try this one

project = "Project ABC" OR (project = "Project DEF" AND labels = LableABC) ORDER BY Rank ASC

[Ronnie Shorto]

That is not valid. I get the following error

Error in the JQL Query: Expecting either 'OR' or 'AND' but got "DEF". (line 1, character 59)

The real project name does have two works within " ". The error references the second word which is why in our example of Project DEF I used the DEF part. I just wanted that to be clear. 

[Nic Brough -Adaptavist-]

It should be valid - could you try typing it and using the suggestions the input box will make, rather than copy/paste?  Or just inserting the parentheses in the working one that you had before?