Trying to use conditional logic in JQL when filtering for issues

[Steve Janda]

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! 

[Steve Janda]

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?

[Boris Berenberg - Atlas Authority]

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.

[Steve Janda]

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! 

[Boris Berenberg - Atlas Authority]

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.

[Boris Berenberg - Atlas Authority]

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?

[Vineet Prakash]

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")

[Steve Janda]

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

Thanks for the input though!