Trying to use conditional logic in JQL when filtering for issues

Hello! 

I am trying to display filter results based on status in JIRA. 

project = ODS AND (issuetype = "A" AND status in (Resolved) AND issuetype = "B" AND status in (Open, "In Progress"))

So I am trying to get issue "B" to display based on issue "A" being completed. 

Is this something that can be done in filters? 

Thanks! 

3 answers

This widget could not be displayed.

Hi 

Try this, it might get work.

project = ODS AND issuetype = "A" AND status in (Resolved) AND project = ODS AND issuetype = "B" AND status in (Open, "In Progress")

Thanks for the suggestion Vineet! I have tried this and unfortunately it did not work. 

Thanks for the input though!

This widget could not be displayed.

The short answer is no. In SQL terms you would need a JOIN, in JQL there is no equivelent. You may be able to get it using an add-on. Are you on server of cloud?

This widget could not be displayed.

Well that's fun... 

I am on server. Do you have any suggestions as to how I could either use a workaround or add-on to complete the request?

Well your example JQL above didn't make sense because it doesn't show any kind of an attempt at a join. Explain further what you're trying to do and we can try and help.

Sure thing!  

I want to display an issue's sub-task, in a dashboard but only if another one of the issue's sub-task is marked as resolved.

So I am trying to get issue "B" to display based on issue "A" being completed. I am pretty new when it comes to dashboard, and filter creation so, any direction would be much apppreciated.

Thanks! 

It's solvable but in a different way. Create a field on Issue B to track when Issue A is done. Change the workflow for Issue A to set the value in Issue B using update linked issue post function. Then just query for issue B and field value.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

115 views 2 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you