Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


JQL to show two projects but different issuetypes in each


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

3 answers

2 votes
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 16, 2023

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

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

Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 17, 2023

@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

Like Laurie Sciutti likes this
1 vote
Laurie Sciutti
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 17, 2023

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

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events