Hi, How could I search parent issues whose subtask meet certain condition

[Shiwei Zhu]

There are some other teams create subtasks in their board and than assign it to my team members.

But the scrum board only show standard task but not sub task in plan mode.

I want to create a filter to search all parent issues whose subtask meet certain condition, is it possible without any additional plugin?

For example, I need some approach to realize:

find_parent_issue_of (issuetype in subtaskIssueTypes() AND assignee = currentUser() AND resolution = Unresolved)

Thanks,

[Renjith Pillai · Accepted solution]

Since you are using OnDemand you have the possibility to get this data externally. Two choices which I would follow:

1. Use one of the chrome plugins like tamper money and embed a small script which can get the REST data of the JQL (sample JQL here) and extract the issue-id of the parent task from the result
2. Simple run a curl in the command line and parse the output of the same REST output

[Shiwei Zhu]

Great! I will try it.

[Andy Nguyen]

Hi Shiwei,

As far as I know, there's no built-in JQL query that can help you to do so and the only way that I'm aware of is already recommended by Udo but unfortunately you're using OnDemand which does not support Script Runner.

At this stage I can only help you to raise a new feature request ticket in our JIRA forum but it may take time for the request to be addressed. Kindly let me know your opinion.

Regards,

Andy

[Shiwei Zhu]

Hi, Andy

It seems I have to handle this case manually.

Anyway thanks for your reply!

Hope your team can help to implement the feature in near feature.

Thanks,

Shiwei

[Shiwei Zhu]

Hi, Andy

I will appreciate if you can help to add the feature to your feature queue.

Thanks a lot,

Shiwei

[Udo Brand]

if you are not on JIRA OnDemand you could use the script runner plugin. This has a jql function which can achieve this, see: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-parentsOf%28Subquery%29

[Shiwei Zhu]

Thank you, but I'm using OnDemand now...

Is there an alternative way by using the original JQL function?

[Udo Brand]

I'm afraid with standard JQL this is not possible.

[Shamee]

The below JQL can be used to filter the Stories which are in certain status based on the subtask status
issuefunction in subtasksOf("sprint in openSprints() AND issuetype = Story and status!= \"In Progress\"") AND project = "XY" AND statusCategory in ("In Progress")