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? :-)

[Joseph Chung Yin · Accepted solution]

@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]

.

[Kevin Dickson]

.

[Joseph Chung Yin]

@Kevin Dickson -

I agreed with what @Laurie Sciutti suggested.  I have also find another issue with your JQL "AND component in (EMPTY...".  For testing issue without component assignment should be component is EMPTY and should not be used in the "IN" operation.

In addition - your JQL of ""Delivery Squad" in cascadeOption(31355, 31357)" seems to be odd the usage of 31355 and 31357.  The recommended way should be the actual option value names.

To obtain the issues from another project (one of your epic moved to another project and its associated issues, you can just add a OR statement to reference and pull content from the other project.

NOTE - Once a board contains content from multiple projects, then one will need "Manage Sprint" right from all the related projects - so you can create/complete sprints in your board (assuming it is a SCRUM board).

Hope this helps.

Best, Joseph

[Kevin Dickson]

Thank you so much @Joseph Chung Yin  and I do apologize for taking so long to acknowledge your suggestion, I've been out of action for some time with an injury.

Your suggestion is very much appreciated.

[Laurie Sciutti · Accepted solution]

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

[Kevin Dickson]

.