Creating a dashboard using a filter which is querying from two different projects

[Tobbe Wilson]

I want to create a filter (to be used by a dashboard) which is showing all tickets from the board CHM that are not Done, and are linked to any ticket in the board IIC which is in the status Live. 

The query below shows all tickets from CHM, regardless of status.

project in (CHM, IIC) AND status != Done AND status = Live AND issueLinkType = "Is under improvement by CMH ticket" ORDER BY Country

 Anyone have any good suggestions?

[John Funk · Accepted solution]

Hi Tobbe,

Maybe (project = CHM and status != Done) OR (project = IIC AND status = Live AND issueLinkType = "Is under improvement by CMH ticket") ORDER BY Country

[Tobbe Wilson]

Hi,

Thanks for your answer!

The OR gives me all tickets in CHM without that status.
(project = CHM and status != Done) OR (project = IIC AND status = Live AND issueLinkType = "Is under improvement by CMH ticket") ORDER BY Country

Changing it to an AND gives no result

[John Funk]

What do you mean by "The OR gives me all tickets in CHM without that status."? It should only give you CHM issues that are not Done. Isn't that what you wanted?

[Tobbe Wilson]

Exactly, It should only give me CHM issues that are not Done, but it doesn't. I get all!

[John Funk]

Can you share a screen shot of that? Because that doesn't make any sense at all.   :-(

[Tobbe Wilson]

Sorry, my bad! I found a typo...

[Jira Guru]

Hi @Tobbe Wilson 

Project=IIC and status=Live and issuelinktype= "Is under Improvement by CHM ticket"

Save the above query as a filter. Say for example, Filter 101

Create another filter like the below and use it in your dashboard

Project=CHM and status != Done and filter in ("Filter 101") ,

Try the above and if that helps.

[Tobbe Wilson]

Hi,

Thanks for your answer!

The first filter works fine and gives me actually the same results as i got from the beginning.

Project = IIC AND status = Live AND issuelinktype = "Is under improvement by CMH ticket"

But when creating the second filter, which is calling this one i get no hits at all.