How to get ISSUES that have test scripts created by current user?

Question

Hey everyone,

I'm trying to write a query that shows me Stories, Tasks, and Bugs (issues) that have test scripts as a subtask.

Ideally I'm looking for those subtasks to be linked to me as well

eg.

Issue1 has (Test Script1 created by currentUser())

Is this possible?

Daniel Ebers · Answer

Hi @daniel.deneal

we found this to be hard or impossible to do out of the box and while we are not associated with the vendor Script Runner was usually something that was used for queries like this in the past.

I could think of the "subtasksOf" function:

https://docs.adaptavist.com/sr4jc/latest/scriptrunner-enhanced-search/enhanced-search-included-functions#id-.EnhancedSearchIncludedFunctionsvCurrent-subtasksOf

Edit: oh, and while I see you asked the other way around - this should also be doable, like:

type IN (Story, Bug, Task) AND issueFunction in parentsOf("type= Testing-Sub-Task and status = Open AND assignee = currentUser()")

https://docs.adaptavist.com/sr4jc/latest/scriptrunner-enhanced-search/enhanced-search-included-functions#id-.EnhancedSearchIncludedFunctionsvCurrent-parentsOf

This should address a good portion of your requirements, however implementation in Cloud is different than in Server - you also please make sure to compare with "enhanced search" documentation before doing any further consideration:

https://docs.adaptavist.com/sr4jc/latest/scriptrunner-enhanced-search

Regards,
Daniel

Jack Brickey · Answer

You need to have some query-able field or condition associated with test scripts. is there any such field?