Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to write JQL query for jira board with multiple projects

Hello, Can someone please help me to write a jql query for project. 

The scenario is this: I have a project, created board with including 2 different projects in it, then I need to filter by epic name's so they will appear in the board which I just created. 

Is that possible?

Thank you for help! 

Luda 

 

2 answers

1 accepted

1 vote
Answer accepted
edwin vasquez Community Leader Mar 17, 2020

Hello @Ludmila Baklanova 

If I understand your question correctly, then yes this is possible.

If you already have the board displaying the issues from two projects if not then use a query similar to this for the board filter.

project in (TestProject,TestProject2)

Then you can just switch the swimlanes to Epics.

swimlanes.pngI hope this answers your question. If not, let me know.

Thank you, the board already have all issues. Now I need to have a query that only show 2 epics from all. One from one project and the other from another. 

Is this possible? So I do not have to view all of the issues from two projects. 

Also, do you know if its possible to query for label as well? 

 

Thank you in advance. 

Luda

edwin vasquez Community Leader Mar 17, 2020

Try this below for your board filter and then change the swim lanes to view by Epic. 

 

(Project = project1 and “epic name” = Epic1) or (Project = project2 and “epic name” = Epic2)

hmmm after doing this - Project = CPE and “epic name” = "WatchTower-Trust Site" OR "Project" = "TACO" AND “epic name” = "Outage Prevention"

It still not giving me the green light. Is it something am I doing not correct?

edwin vasquez Community Leader Mar 17, 2020

Did you use the parentheses like in my example?

yes and that did not work, so I change it. Is that not correct? 

edwin vasquez Community Leader Mar 17, 2020
(project = CPE and "epic name" = "watchtower-trust site") or ( project = TACO and "epic name" = "outage prevention")

try this. 

ok :) it worked. But will it show all the stories under them? or is it only epics? 

edwin vasquez Community Leader Mar 17, 2020

It will show all issues. If you want them sorted by Epics, change the swim lanes to Epics.

If this has answered your question, please mark it as answer.

one last question - is it possible to add to this filter additional labels?

edwin vasquez Community Leader Mar 17, 2020

Yes, you should be able to add or remove as much as you need to make the query work for you.

thank you bunches!

Hello Edwin, can I ask you for help. I need to write a query to gather view on one board with 2 projects but same label in both projects. 

Thank you, 

Luda 

Hi @Ludmila Baklanova 

You may try the following query:

Project in (Project1, Project2) AND labels in () order by created DESC

The other option, if you found some issues with JQL, you can try Dynamic filters: JQL Replacer add-on. It is developed by my team to simplify advanced searches. It's easy to set data with the help of visual composer as shown below. 2021-04-26_12-43-34.png

As result, you've got issues with the required label for 2 projects.

2021-04-26_12-45-25.png

Hope it helps.

Kind regards

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you