You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I'm trying to create JQL to show filtered items in two projects A and B.
Help please? :-)
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
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
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.
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