Hi,
I was wondering if it's possible to set up a filter which returns the ID of the Parent Jira based on the status of a sub task. So for example if the Sub Task Status = InProgress then then Parent ticket is returned in the filter?
Many thanks
For anyone who might be having the same issue, I did manage to solve this using the following JQL search:
issuefunction in parentsOf("project in('xxxxx' AND issue type = 'xxxxx' AND Status in ('In Progress')")
Hello @Daniel
Welcome to the community.
Are you using Jira Cloud or Jira Server/Data Center?
Does your Jira instance have any apps that extend the searching capabilities? You may have to ask your Jira Administrators about that.
I am not aware of a way to directly return that result through regular JQL without some background work, though you can eventually get to a JQL solution by doing some automation to identify when children are in progress and then flagging the parent issue. It's not a trivial task, however.You can (in jira automation) run a global rule that watches the children of a set of tickets and toggles something (custom field, label, etc) when the rule detects that the children are in progress. That can be done with several triggers (each will have different logic too)The relationship can be fairly complicated to set up, since there are different functions for Parent/Child when you're referring to Epics and Stories (and other standard issue types), and story/sub-tasks, AND if you have hierarchy levels above Epics on Premium Cloud.You can also likely determine that through scriptrunner or the API, but the solution requires custom work in all cases. There also may be addons to do this, but I don't know of any off-hand.
I believe it's a Jira server and I'm not aware of any apps that could do this no. Thanks,
Thank you for your response, it sounds like it plausible that way but I think it's best if I don't overcomplicate it and stick with a label method for now.
I thought it was a longshot, but wondered if there might be a fancy JQL function that I hadn't considered.
issuefunction is not standard JQL, so this only works if you have scriptrunner or another addon that enables it.
Based on you self-posted answer, it would appear that you have the third party app Adaptavist Scriptrunner in your environment.
It looks like you're new here. Sign in or register to get started.