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; } } }

Fetch data from 2 different projects with a filter applicable to 1 project

Debashis Pyne

Hi,

I am trying to extract data from 2 different projects with a filter applicable to only 1 project.

The query is as below:

project in (P1, P2) AND component = C1 ORDER BY key DESC, status ASC, summary ASC, Rank ASC

In above, P1 doesn't have the component filter however P2 does.

P2 has a lot of other records, however I wanted to extract with this component filter only.

The results do not show any records from P1.

Please advise.

Accepted answers

Nic Brough -Adaptavist-

This is correct. Your filter explicitly excludes issues from P1.

By definition, issues in P1 cannot have component C1, so your filter won't ever get anything from it.

If you want to see issues from P1, include them in your filter. Try

( project = P1 ) or ( project = p2 and component = C1 )

All comments

Nic Brough -Adaptavist-

This is correct. Your filter explicitly excludes issues from P1.

By definition, issues in P1 cannot have component C1, so your filter won't ever get anything from it.

If you want to see issues from P1, include them in your filter. Try

( project = P1 ) or ( project = p2 and component = C1 )

Charly _DEISER_

if i understand correctly your problem is in the AND clause, if P1 does not have this component you are not going to get any tickets.

Try something like this:

project = P1 OR (project = P2 AND component = C1) ORDER BY key DESC, status ASC, summary ASC, Rank ASC

this will get all of the tickets from P1 and only the tickets from P2 where the component is C1.

Hope this helps you.

Debashis Pyne

Thank you so much!.. This works

Welcome!

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

Quick Links

Find more posts tagged with

jira