Tricky jql to show issues where a linked issue meets a specific criteria

[Sonja Altmann]

Hi there, 

I dont know if I can do this with JQL, so asking here to see if anyone can help me.

I have a JPD Project with a field "Roadmap"   Project:  AFP

I have a Jira project (FEAT) which has issues linked with "implements" link to AFP

I want to find all FEAT tickets where their linked AFP issues has a Roadmap field of "Active"

Can this even be done?

[Prosper Agwegiokhe · Accepted solution]

Hi @Sonja Altmann

I’m Prosper, a support engineer at Appfire, and I’m here to help you.

If you are open to 3rd party solutions, the app I work for, JQL Search Extensions for Jira, you can use the query below to get the results for your use case:

linkType = implements and project = "Feat" and "Roadmap field" = "Active"

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

[Mohamed Benziane]

Hi,

This is not possible with JQL out of the box. You will need to use an add-on, or create an automation rule that will add a value to a custom field, then use a JQL query to find issues that have a specific value in that custom field.