Join statements to query to projects.

[Thomas Fritzen]

How would I write a query to get result from 2 different projects.  

project = "Quality Suite" AND fixVersion = "7.69 Island Fortress - In Dev" AND project = "iOS Diner App" and fixVersion = "7.69 Island Fortress - In Dev"

[Thomas Magny-Garcia]

Hi @Thomas Fritzen ,
You should use "OR" and parenthesis instead of "AND", I guess.

Because the issues you are looking for either in your Quality Suite project  OR in your Diner App project. I don't think there are in both of them :)

Hope it helps!

[Thomas Fritzen]

thanks that does help but it is not bringing back what I want. So I have a Project IODA and then I have another Project Called QS. Our QS is Zephyr and IODA is JIRA.  We connected User Stories to Test Cases using the is related to field in JIRA.  So User Story IODA-1234 is covered by Test Case QS-1234.  I want to show a matrix of what Use cases we have for a release and what test cases cover that user story.  Is that possible?  

Thomas 

[Alexis Robert]

Hi @Thomas Fritzen , 

you can simply add () to your query and add OR, like this :

(project = "Quality Suite" AND fixVersion = "7.69 Island Fortress - In Dev") OR (project = "iOS Diner App" and fixVersion = "7.69 Island Fortress - In Dev")

Let me know if this helps, 

--Alexis