Hi community, I'm trying to create JQL to show filtered items in two projects A and B. * Show all epics, stories etc. from Project A * Show only the epics from project B. Help please? :-)

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

JQL to show two projects but different issuetypes in each

Kevin Dickson

Hi community,

I'm trying to create JQL to show filtered items in two projects A and B.

Show all epics, stories etc. from Project A
Show only the epics from project B.

Help please? :-)

Accepted answers

Joseph Chung Yin

@Kevin Dickson -

Try the following JQL -

project = prjA and issuetype in (Story, Epic) or project = prjB and issuetype = Epic

Let me know if this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

Laurie Sciutti

Hey @Kevin Dickson ~ I agree with @Joseph Chung Yin but if that isn't working for you what you might try first to simplify that JQL is to use statusCategory != Done (assuming all the status values listed are in the "To Do" or "In Progress" statusCategory) instead of the status in ("In Progress",...). That would clean it up a bit...

Then you could add: or "Epic Link" = XYZ-123 or key = XYZ-123 to include the Epic and associated Stories that were moved to another project. HTH

All comments

Joseph Chung Yin

@Kevin Dickson -

Try the following JQL -

project = prjA and issuetype in (Story, Epic) or project = prjB and issuetype = Epic

Let me know if this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

Kevin Dickson

Thanks Joseph, I tried playing with that but no luck.

The below shows the current query, but the issue is that one of my epics (and associated stories etc.) has now been moved to another project, but I still need to view it on my board.

Please excuse the long query, I've inherited this and trying to simplify.

This is the (current) query:

project = UID10894 AND issuetype in (Defect, "Enabler Epic", "Enabler Story", Epic, IM, Objective, Story, Sub-task) AND status in ("In Progress", "To Do", Implementing, Design, "ETE Testing", "Product Backlog", "QA testing", "On Hold", "Ready for Development", "Ready for Production", "Ready for QA", Analysis, Funnel, Analyzing, "Validating on Staging", "Deploying to Production", Releasing, "ETE Failed", "QA Failed", "QA Pass", "Ready for ETE", Refinement, "Technical Design", "Retest failed", Monitor, "ETE Pass", "ETE Hold", "ETE Retest", "QA Hold", "QA Retest", "In Development", "Business Validation", "CX Design", "PO Sign Off", "Production (Project Warranty)", "UI Design", "UX Design", "Dev Pass", "Dev Failed", "Pre-Prod (Staging)", "Pre-Prod Pass", "Pre-Prod Failed", "Pre-Prod Retest", "Pre-Prod Hold", "Dev Retest", "Dev Hold", Copywriting, "Copy Review", "NELS Review", "Usability Testing", "Tempo On Hold") AND component in (EMPTY, "Business Partner", BW, "Collateral - Loans", Condition_Flows, "Correspondence - Loans", Direct_Indirect_Data, Direct_Indirect_LIFT, Direct_Indirect_Risk, "Property - Loans", "Risk Squad", SL_Data, SPV, Steercom, "To be updated") AND "Delivery Squad" in cascadeOption(31355, 31357) ORDER BY Rank ASC

Kevin Dickson

Laurie Sciutti

Then you could add: or "Epic Link" = XYZ-123 or key = XYZ-123 to include the Epic and associated Stories that were moved to another project. HTH

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-service-desk-server

jira-service-management-server