nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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,

Accepted answers

Renjith Pillai

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

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
Simple run a curl in the command line and parse the output of the same REST output

All comments

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?

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

Udo Brand

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

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

Renjith Pillai

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

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
Simple run a curl in the command line and parse the output of the same REST output

Shiwei Zhu

Great! I will try it.

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")