nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

John Funk

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

All comments

John Funk

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

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.

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software