If you want to use DB (SQL) as a workaround you can do that via query:
FROM AO_7DEABF_STEP_DEFECT, jiraissue
WHERE jiraissue.ID = DEFECT_ID
AND jiraissue.resolution = 'your resolution id'
AND jiraissue.issuestatus = 'your status id'
You can only use ZQL in the Zephyr Search Test Executions navigator and you can only use JQL with Atlassians Issue navigator. It is not possible to mix ZQL and JQL. Thus you will not be able to half search for something in Zephyr and then search the rest in JIRA.
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!
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