Can I use JQL to identify Bugs linked to Test Scenarios from one phase but not to another?

[Kevin Costello]

My company is currently transitioning ERP systems and using Jira to track the project. We are about to enter phase 2 (P2) of testing and we want to be able to build a query in regular JQL (sadly no ScriptRunner add on) that would return open Bug tickets linked to a Test Scenario issue where affected version is Phase 1 (P1) but not linked to a scenario where the affected version is P2. Is there a way to do this? Even with a workaround such as creating a filters that that get used in the query would be fine. I am just hoping there is some way to do it.

Thanks in advance!

[Hauke Bruno Wollentin]

AFAIK this is not possible with the default JQL functions.

If ScriptRunner is not an option, you could try writing an automation rule that triggers if your bug tickets get linked and than set a custom field to your project phase.

Just a text field would do, maybe select field also.

This allows to filter just for the Bug issue type + "P1" as a value of that textfield/select field.

Not that intuitive, but it should work out just having the project phase as an attribute on your bugs 😬