Jql get parent of subtask. Improve this question .

Jql get parent of subtask Please may someone tell me if this is po You can change a status of a subtask by dragging it from one column to another (for example for Open to Awaiting QA). Story A has sub tasks X, Y ,Z Story B has sub tasks Q,R We want to get a results set that looks like this (We don't care whether B will show up before A). I have a task = SI I'm trying to create a JQL filter that will remove all the tasks that are linked (child of, parent of, etc. I thought it would be cool if I could click in a task and then hit a quick filter Jira Expressions allow you to send along a JQL query and then run them on a list of the results. Finds issues with sub-tasks, eg To find sub-tasks that are Open, but their parent issue has a resolution of Fixed, you could use: issueFunction in subtasksOf("resolution = Fixed") and status = Open . Table Person. . It also extends to any issue at the same level as its parent issue (e. My task Status changes correctly, however the cloned Subtask Status is not cloning over correctly. Add a comment | 6 . However, the for loop is not checking each element of the collection just the first one. But I need Story issues with subtasks which are in analysed. Thanks. (The parent task need not be assigned to current user) issueFunction in parentsOf("assignee = currentUser() ") Below JQL-query worked for me, giving me all subtasks and linked issues to my AC-15 issue: parent = AC-15 OR key in linkedIssues ("AC-15") What above query says: Fetch I want to show a list of all sub tasks open and the related parent issue in a column. Viewed 233 times 3 . I just need to be able to roll up the time spent on sub-tasks to get a final time spent on the story. dlugoszewski: type = sub-task and status = Open and issueFunction in subtasksOf("status = closed") With only native Jira JQL functionality there are limitations on what you can achieve. However if you want to see the subtasks directly under their parent issues, you might try to order by I want to write a query in which I want to provide the parent bug id and it should return me the value of "Approved" for each of the sub-tasks of the parent bug. 1 - 'Label1' - Closed ---Sub-task 1. and it is part of Script Runner Atlassian Team members are employees working across the company in a wide variety of roles. Hello, Currently I am using IBM EWM 7. First of all, I modified "(query #1) OR (query #2)" JQL with adding key of the parent issue here, because this issue have to match JQL I'm in search of a possibility to filter out issues with a subtask. Hi. print "Parent %s of subtask %s" % (issue. Please try: declare @id I've been trying to write a JQL query that selects all sub tasks for all stories which have a specific status. I know I can use the "Group By" drop down, but that only shows the subtask in my project columns. I have not found a way to display both the part type = sub-task AND status != Done AND parent = The parent field only supports search by issue key or by issue ID, not by another query. , Parent issuetype has 2 different sub tasks. Ooh nice I've if "KEY-123" is an Epic, the query returns the Parent (e. I want to use Jira Query Language to find the tasks which all their sub-tasks are in 'done' state. Let's say that I have 3 issues: A, B (which is a subtask of A) and C, which is linked with B and isn't a subtask of A. For one single line of code the price is absolutely insane tough. Hi guys, here is my scenario: I have a scrumboard (active sprints) for my team and we have a HomeOffice time for now. key}} AND summary ~{{triggerIssue. JQL to search subtasks of not completed stories. My requirement to is fetch parent records which has only contains Actions. Example : parent = YOUR_PARENT_KEY_HERE. I am struggling to come up with a query using Jira + ScriptRunner that finds all parent tickets that are missing a subtask with that specific label. In addition to this suggestion, in case you want to retrieve subtask issues matching an specific summary but in a list of dynamic parents you must go for a third-party app. Improve this question . subtasksOf is analogous to saying "sub-tasks which have a parent selected by the Basically I am trying to take the required parent due date, subtract 14 days from it and apply it to my subtask's due date field. Hello, I am trying to create a filter that will display all parent issues and all its subtasks when at least one of the subtasks is assigned to the current user. I tried this way, however, It will only show description of the parent and not the key or issue number , I want Parent issue key to be shared You must be a registered user to add a comment. I'd like the JQL to return the status of that 1 subtask if the other subtasks are in Done. Modified 5 years, 1 month ago. Leonard Chew. Share. Hi everyone, When using the childIssueOf() in ScriptRunner on a Story Key, I can get all the Story Sub-tasks as shown below: It would stand to logic using parentIssuesOf() on any of the resulting Sub-task Keys that I should get the parent Story (295) and subsequent parent Epics We are recording the parent key of the subtask, currently this is the task/story still. jira; jql; Share. JQL Via Scriptrunner Filter 1 (Get Epics linked to parent Initiatives) - issueFunction in portfolioChildrenOf(" project = ABC ") How can I query all the subtask of a specific type regardless of parent? Alexandra Moraru. I'd like not to use plugin but if it's not possible, i will take scriptrunner. One of those subtasks should be - for example - a user testing subtask, flagged with a label like "UserTesting". My requirement is When all sub-tasks are Resolved for a parent and parent status should not be Resolved. I have got two tables as following. Story - Sub-task relationship) by using something like below: issueFunction in subtasksOf("project = <your-project> AND issuetype IN (x,y,z)") I want to get all issues that don't have or have parent. I Was SCARED To Say This To NASA (But I said it anyway) - Smarter Every Day 293 youtube upvotes · comments. In this case the Scriptrunner provided JQL function, aggregateExpression is still not going to change the values pulled in by the rest of the JQL query according to the documentation of this function. This gadget returns values based on the JQL filter you use. Like Celine BEUCHET likes this . Details. However, I now tried to create a new epic and then it actually worked. Is there a way in which I could get the epic for an issue ? The api returns a lot of information about an issue, but the epic is not included. issueType. I can add story points to appropriate fields of sub-tasks. LinkedIn; Twitter; Email; Copy Link; 17494 views. I don't mind using a plug-in to do this, I know ScriptRunner, Search Linked This should return all Stories and all the subtask of those stories. Jql : ( issuetype = Story AND status = "Open") AND subTaskStatus = Closed (for Cloud) ( issuetype = Story AND status = "Open") AND issue in subTaskStatus("Closed") (for Sever) 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. Connect and share ideas at events See the calendar →. Modified 1 year, 4 months ago. Maybe if you would create some custom field and make it appear in Hello Bil, this is a brilliant idea but I see now that "lookup" function is neccesary here. The JQL runs and finds subtask keywordB under X-2. Sub task 1 is an Action and Sub task 2 is a Question. Modified 7 years, 3 months ago. · Jira Filter with "parent in" (by Hansi at ATLASSIAN Community). This works if you want to do a one-off analysis. In the app where my team works, JQL Search Extensions for Jira, you can use this query to see all sub-tasks whose parent is a Task: issue in subtasksOfParentsInQuery("type = Task") And you can use this one to see all the Tasks that doesn’t have sub-tasks: I think if you have an add-on like ScriptRunner, you can filter the issues that have a specific parent issue type (assuming, that there is a parent-child relationship between these issues, e. You can add the sub-task column to get the issue link for the tasks themselves. Is there a possibility to filter by the parents epic link? so a JQL query could look like this: "Epic Link" = epic OR parent. ParentId ChildId 2 1 3 2 4 3 This will form When a certain subtask is created, I want it to be linked to its "sister/brother" subtask that contains a certain word in the summary. Hi, That is not working, because remainingEstimate is set when I log a work in the parent issue, but all the worklog are in the subtasks so the remainingEstimate that I see in the parent issue is the sum of all the subtask's remainingEstimate. What I would like to do is get back the subtasks in the results rather than the just the parent issue. I am trying to find a way to sum story points of sub-tasks into their parent issue. Initiative), as well as all issues beneath that highest level in the hierarchy (Initiative), and any adjacently linked issues, dependencies, related issues. For example, we have an issue called "Large Story" and under it, there are two sub-tasks w In your FOR JQL branch, I would try to get to the exact issue(s) you want to modify first of all in one go. Viewed 69k times 24 . 1 subtask is like a placeholder. I'd like to see aggregations by epic, then by story, with the leaf level being the subtickets on a story item. I want to use custom JQL filter to see the parent story and subtask in my project columns. e. Commented Jan 29, 2021 at 3:10. Employee where @h. I'm using the JIRA REST API (https://developer. To learn more about how we Get early access and see previews of new features. 0(which is my project's specific fix version), and also selects subtasks within it. 2 version. key}}) and the action is to transition the issues to match the trigger issue. The only similar question that I found was "JIRA JQL - Find all subtasks that are open where the parent is closed" which was answered by @g. JQL does not behave like SQL. The task has x number of subtask and I want to show the ones that are in progress and which task number is. Hope that helps! Cheers, Andreas. We gonna to use this variable in the next step. Any help will be appreciated. EpicLink = epic. Modified 3 years, 11 months ago. Viewed 3k times 5 . In the above while the "status != Done" is working and checks the Subtasks, The issue. Project = ABC and type = subtask. parent. Kuf Kuf. I compared all the subtasks under the story and the only thing that stands out is that the 1 subtask used to be a story. Rising Star. key}} is null I was trying to exclude all subtasks from a specific parent key and used the below query. – Douglas Marttinen. You can use a JQL like this issueFunction in subtasksOf("key=A-1") that will list all sub-tasks of A-1 with their status. I can put in your JQL suggestion to get my extract but I need te build a JQL Issue Filter where I would like to get as a result: All Epics with the Label "ABC" + All the Issues/Stories (with or without any label) belonging to these Epics + All the subtasks (with or without any label) belonging to these Issues. parent, issue. size is a great solution. munchine munchine. Erin, reading your question about the Lookup Issues JQL, to get sibling issues of the same parent, try checking the parent. r/SmarterEveryDay. key. You can use the query: issue in ChildrenOfIssuesInQuery("{jql function}") To get the children of a parent task. I need this query to select sub-tasks that isn't assigned for that version. For Halley's case she could also do one branch on JQL where the JQL is key in ({{issue. I thought it would be cool if I could click in a task and then hit a quick filter that would hide everything else except for the tasks of the parent epic. use JQL to find the subtask for that parent issue parent = {{triggerIssue. last}} With standard JQL, you can only get a list of issues and export them to Excel for further processing. Dates. Join a community group Find a group →. I want to set the parent to Apr/20/20 and then the subtask automatical I am afraid that you could get not these results with the native JIRA features. Any help would be Scenario : When subtask status in "Delivered", then it should check . e. I have tried to Google the problem, as well as check through SF, but did not find anything. Log In. issuetype = "Sub JQL is missing the function to look up what issuetype the parent has. first}} action: create a variable to save the {{issue. This fine but it get confusing for some. How do I query issues that have sub-tasks assigned to me? Resulting issues may or may not be assigned to me but they must contain Parent Issue : Project Linked issue: User Story Sub-Task : Task I am looking the query to find Parent issue (Project) linked User stories and SubTask. Get early access and see previews of new features. Modified 8 years, 8 months ago. Hi ,I am looking for JQL which will only give me that issue numbers which does not contain any subtask. summary is returning the contents of the Parent, what am I missing to pull the Subtask summary instead? Hi, I'm looking for solution to search a parent record based on specific sub-task. Comment; Srikanth Vemuluri December 9, 2022 . If some are in progress, I transition the parent issue to "In Progress". It's not a trivial task, however. key}},{{issue. Modified 2 years, 4 months ago. That way the total estimate that flows up to the parent is eight Hi, We want to create a query that will show up issues (Stories and associated subtasks) in a certain order. I was thinking about: issueFunction in hasSubtasks() AND status = analysed. So what I have is 2 related issues actions 'For parent' with a related issues condition that uses JQL to find all sub-tasks of a given type parent = {{ issue. size|0}} equals 0 Hi, i want to have a filter that gives me all issues with a specific epic link and all their sub-Tasks. id value of the parent, and destination is branch: on JQL for the earliest Start Date, key = {{lookupIssues. issuetype in (Bug, SubTask) and issueFunction in linkedIssuesOf('filter = MyFilter') You can provide the optional second parameter in the linkedIssuesOf JQL function (which is nothing but the link type) and if you choose not to, then it provides with all the tickets under the UserStory matching your issuetype. I've been trying with 'In parent' and stuff but couldn't figure out how to get this without using plugins. assignee = <USER> or assignee is EMPTY But this shows also Stories was able to figure out the JQL " issueFunction in subtasksOf('DevPriority = "1 (Very high)"') " Reply reply LessCaterpillar9775 • Help With Board Query (FixVersion of Parent = q2) comment. How to get specific assignee of a story, subtask with a specific summary in JIRA? Ask Question Asked 3 years, 7 months ago. project = XXX AND status = Open AND issuetype = Sub-task AND labels = XXX. The problem is that stories exist in one workflow where as my sub-tasks exist within another. But, IMO, it needs to be tweaked as follows: 1. You can get all the subtasks under a specific issue using a filter like this: parent={issue key} and issuetype in subtaskIssueTypes() To get the subtasks of multiple issues you could use: status in ("Open") AND parent in (PHX-xxx,ENG-xxx) It will give you all the open tickets present as a subtask in parent JIRAs. null View workflow XML Word Printable. Give a try, trying to build the filter and using the gadget. It is just giving me the output if there is any one subtask has more than 10 hours. I'm also sending you documentation, regarding to using gadgets and creating filter on JQL. key) You must be a registered user to add a comment. I am trying to create a custom search that lets me see the subtasks I touched of tasks that are still not done. Contributor. Is this a bug? I Hi Mo. The following query will return all parent tasks, which have sub-tasks assigned to the current user. How can I do you can use field parent to do that. If I change the subtask's status not by drag-and-drop but using the drop-down menu of the subtask itself, it completely disappears from the sprint work overview (but it still exists as a subtask of the story). In a given parent issue, I have 3 subtasks. We tried the app "Scriprunner" and it works great, fantastic. Query to get all subtasks associated to stories with some labels in Jira. August 21, 2017 . The JQL you're looking for should be like this: type = sub-task and It would be very helpful to get the parents of a group of subtasks via JQL. Subtasks JQL Aliases ParentSummary Hi, What I want to do is write a jql query that, selects every tasks in version 4. I have this but it is not sum of all subtask. November 9, 2018 . GetAncestor(1); While this will get you all of the managers up the chain: select * from dbo. 5. Modified 3 years, 7 months ago. Comment; Like. This query finds finished issues with unfinished subtasks. What would the JQL code be for that? I Ask questions and find answers on Jira. I tried the following query for issues without parent: issuetype in ("Epic","User Story") AND "Epic Link" is EMPTY but I’m not sure this is returning what I expect. Community; Products; Jira; Questions; how to list all items excluding subtasks; how to list all items excluding subtasks . The next question is "Do you need to sort this data in a specific way?" You could then add an. /Stories . g. Been trying to work it out by googling, but Been trying to work it out by googling, but Atlassian Community logo Is it possible to use JQL in the Confluence JIRA Issue/Filter macro to display a table of all the issues of a Portfolio Initiative? The link above seems to be creating a query in Portfolio itself [ issuekey in childIssuesOf("INIT-001") ], but I can't seem to find equivalent JQL syntax that will work in the Confluence macro to retrieve the issues. Follow asked Jun 21, 2017 at 3:14. Export. Product Q &A Groups Learning Hi ,I am looking for JQL which will only give me that issue numbers which does not contain any subtask. Looking at JQL tricks, I see there are functions called "issue in subtasks", "issue in parent" but not sure how can I get this accomplished with any of the functions available. Build more complex and enjoy using JIRA. The issue link table has the following fields: | id | linktype | source | destination | sequence | Where source is the jiraissue. Examples: issue in subtasksOfParentsInQuery("status='Done'") and status='To Do' finds subtasks that are in progress and have finished parents issue in subtasksOfParentsInQuery("assignee=currentUser()") finds subtasks of my issues. I can't find something similar to get all the child issues, other than the mentioned JQL, and neither can I have a branch inside a branch, which would probably solve my problem as well. Add a new action called: lookupIssues > for JQL space insert this value: key = {{your-variable}} We are entering inside Story/Task (parent of subtask) to be able to get your parent (epic) details. Out of the three subtasks, I would like to move only the issues i. We can achieve this using four filters in Scriptrunner's JQL functions, but it'd be great if Portfolio's JQL could handle it in one. Ram On the surface it should be very easy to form a JQL to return only subtasks but I expect there's more to your inquiry. Now, being in issue A (current issue), I would like to do a JQL query to get all issues that are linked with any of my subtasks, and in this case it should give me C, as C is linked with B, which is a subtask of the current issue, A. name == "Epic") Which will give you a It's not possible with JQL out of the box. My goal is for the Task and Subtask Status to get cloned over as well. summary ~ 'Anhang Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. Id Name 1 A 2 B 3 C 4 D 5 E Table RelationHierarchy. I tried below JQL's project = RQM AND issueFunction in parentsOf("status in (\\"Open\\", Pending, \\"In Progress\\") AND As Jack already suggested, given a static list of parent IDs you must use parent field in combination with issuetype and summary fields to retrieve the desired subtask issues. Hope you can help. Rising Stars are I am wanting to add a rule in Automation for Jira that changes the issue type of a sub-task, on creation, based on the issue type of the parent. I tried quite a few variations of the In my case without subtask Parent ID I have to re-type 16 times all of these 60+ subtasks! By the other hand I can create a Jira Plan based on my Scrum Board, where I perfectly see the whole project with tree structure: Solved: Hi, I am trying to write a basic JQL query to show all sub-tasks under a particular issue type. If you've already registered, sign in. assignee in (<jira usernames>) AND status not in (Closed, Done, Complete, Resolved, Cancelled) AND project not in Are you not simply trying to get to the Issues parent or are you trying to get the other Subtask? LookupIssues and LinkedIssues are Lists. I know I have noticed in the new view of Jira , it is not clear (to me anyway) on how to see the Parent of a subtask. key}} and issueType = subtask; Kind regards, Bill. JQL to get the parent of a subtask. Created: 01/Mar/2013 8:04 PM Updated: 29/Oct/2019 7:02 PM Resolved: 21/Jun/2013 8:45 AM In Jira, the parent issue, child issue/subtask relationship is stored in the table issuelink. Obviously, this will add a fair bit of complexity to your JRACLOUD-31922 JQL to get the parent of a subtask. That causes the rule to run, and run the JQL to find subtask keywordB under X-1 and update its Start date. Given the parameters of your scenario, native JQL capabilities are not able to meet your requirement. summary}} AND issueType = Subtask and key != triggerIssue. Hope this helps! JQL; Epic (parent) Parent (these are all in relation to the trigger issue) So in other words, you can find the 'Linked issues' of a trigger issue, or you could find the Epic of the trigger issue etc. Some more info: Issues (Stories, Tasks) have sub-tasks under them. Hierarchy like below Project ID Project summary Project Stauts Underneath User story ID User story Summary and User story status Undern To get all User Story that have an assignee, here is the JQL to run : issuetype = "User Story" and assignee is not EMPTY And to get all the subtasks in these user stories, you must use the issueFunction subtasksOf, with the previous JQL. Examples KO : - parent in ("Labels = Lead") - issueFunction in subtasksOf("labels = client") --> impossible to The closest approach I've found is to not supply any estimate to the parent issue, and then supply a total estimate of eight hours across all the subtasks. I want to make a new branch in the automation and there I want to use JGL but what do I need to write in there? For the certain word I use . With the box checked the rule says · JQL to show all issues AND subtasks in the Epic (by Nathan at ATLASSIAN Community). I'm trying to figure out JQL for a parent task whose original estimate is 0 but the subtask has been estimated. I tried If you want to run your search dynamically, without manually "stitching" two queries together, you'll need extra tooling: You might be able to use Jira Automation to "propagate" parent information down to the parent's children, and then use the respective field(s) on the children to include them into your filter. Hope this helps, Fabio So in your case, you would send the following JQL: issuetype = Sub-task. Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service: JQL Search Extensions So I want JIRA to return all stories with subtasks and the component of that subtask is xyz1234. name == "Epic") Which will give you a JSON list of those sub-tasks that have an Epic as their parent. Hopefully there is some JQL that I could use to get these subtasks (and details) in the results. Obviously, this will add a fair bit of complexity to your system. Which query can I use for that? jira; jql; Share. Like • # people like this . issueFunction in parentsOf("issuetype = sub-task AND remainingEstimate > 10h")) I'm fairly certain JQL does not automatically return counts of subtasks in a query because when I exclude subtasks in a query I get the same count as when I did not. Filter to show sub tasks of a filtered list of parent tasks. here is the JQL to run : issueFunction in JQL to show all parent issues where at least one subtask is assigned to the current user . All of the Subtasks under that Requirement/Story has the sprint field set to the same value so I don't think that would be the reason. IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC If you’re just trying to get the subtasks under a given issue you can simply use: “Parent = KEY-1” AND (some criteria) or for multiple issues: “Parent IN (key-1, key-2, key-3) AND (some criteria) JIRA filter subtasks by parent type. I am trying to make field value/change on a parent trigger an action on children. Later on I'll use that count to run a post function which will based on the criteria that if count<10, then create a clone of subtask, else not. following query will give you the required results. Ask Question Asked 11 years, 6 months ago. If you are certain they contain only one issue in your case, you can access the first element (which will be of Type "Issue") by get(0) or "First" so accessing the first Element's key in LinkedIssues of the Triggerissue should look like: If so, you could use Lookup Issues with JQL, and if the resulting count of issues is zero, create the issue. Mind that there are 2 kinds of subtasks on default, subtask & sub-task so you might need to try both of them, in the filter view add 'Parent' column Although without detailed view I'm not sure if you would be able to see the assignee of both Task and subtask at the same moment. People. Feedback Policy: Our product teams collect and evaluate feedback from a number of different sources. Learn more about Labs. Viewed 6k times 0 . Ask Question Asked 5 years, 1 month ago. Is there another way to hide certain Sub-Tasks or does a free Add-On exist that adds the requied functionality to JQL? But again the simplest way is to have a JQL function that provides you the set of sub-tasks given the nested criteria. Jira seems to have the concept of the other way around (for example, when all children are done, close parent). You can create a filter such as this: issue=ABC-123 or (parent=ABC-123 and issueType=Sub-task) That filter will get you issue ABC-123 and all its sub-tasks. 499 1 1 gold badge 11 11 silver badges 24 24 bronze badges. Members Online. Scrumboard Filter issuetype = subtask AND parent assigne = CurrentUser() Ru Ch. It returns issues based on conditions and does not provide a view or combined results. Currently, I can get results for both parent and sub-tasks for which the original estimate is 0 but need a way to get results only for those parent tickets which has not been estimated but their substasks has been. Viewed 2k times 4 . On the online community, they serve as thought leaders, product experts, and moderators. filter(i => i. But at subtasks level there is no labeling. 9, where I am running the following query in its search option. To be able to get the results through the Advanced Get early access and see previews of new features. Commented Jan 23, 2021 at 8:54 @AvinKavish if I'm understanding correctly, I think you can create a function with the above query, then use the function in your own query to get the root ID of each ID. I've gotten close using the following query, but I don't know how I can reference the parent/child issue's field instead of using Hello, Is it possible to search with JQL for a sub-task where all the other sub-tasks of a parent task except the one being searched for have the status 'closed'? For example, I have the following structure of issues - Parent Task1 ---Sub-task 1. Earn badges and rewards Level up →. With the Task query I can see the info from the below image, but what I'm trying to achieve is to add the subtask(I plut in red what im trying to get) So far I have been reading documentation but no lucky with the info. 1) status of parent issue (parent status should be "baseline") 2) issuetype of Parent issue (Group, test) 3) if above 2 satisfies then copy fields from subtask to Parent . On Wednesday you update the Due date of subtask keywordA under issue X-2. Ideally, I'd like to say: parent IN Some time ago I also needed a custom JQL. Vanessa Thivierge. The issueLinkType field will let you search for issues that have links to other issues using a particular Link Type, but will not let you also constrain that by specify the linked issues have to be in a specific project. Advance your career with learning paths Take a free class →. How to find Jira tasks with all sub-tasks 'done' Ask Question Asked 8 years, 6 months ago. Assignee: Unassigned Reporter: Dustin Chesterman Votes: 0 Vote for this issue Watchers: 4 Start watching this issue. This means that my original idea does not work: type = sub-task AND status != Done AND parent = (type = story and sprint = "Sprint 1") ###Note### I am in no position to use plugins. issue in Hi Guys, I can find Name of Parent Link using Parent Link function but not able to get status of Parent. sub-tasks 2 and 3 to be in Blocked status not the first one in the chain. Worked for me. and all these have some custom attributes which populate the data through If you want to run your search dynamically, without manually stitching two queries together, you'll need extra tooling: You might be able to use Jira Automation to "propagate" parent information down to the subtasks, and then use the respective field(s) on the subtasks to include them into your filter. 17. For a given JQL subquery it finds subtasks of resulting parent issues. 1 vote . The problem is that when I use the parent field in the jql query, the epics don't come up in the suggestion list when I start typing the name of the epic. The JQL would be something like: project = myProject AND issueType = Subtask AND parent = parentIssueKey AND some other criteria. Now, I can create a jql with a group by "Key, Parent" where all the sub taks are grouped together by their parent, but not listed directly under I would like to get a summary report of my sprints and what happened with my tickets. Learn more about Labs . Project type : Team managed project Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. I am trying to get the list of child and all sub child for the parent. Thanks for reaching out! No, what I try to do is just to get the list of all the issues belonging to a certain epic in the issue navigator. So in your case, you would send the following JQL: issuetype = Sub-task. I want to create a database that keeps track of a list of tasks that the users need to do and in the list of tasks there will be subtasks and sub I am an admin using a Team-Managed project, and would like to view the parent story and the subtask on the Jira board at the same time. Feature) and the Parent's Parent (e. For example if the hierarchy is EPIC -> Task -> Story -> Sub-Task, if I provide an epic or list of epics, would need the all the tasks under epics, all the stories under each If you are open a plugging suggestion, you can try out our App JQL Search Extension for Jira. Using Atlassian Cloud @Ste Wright idea of using automation and the issue. I'm not a programmer but I took several things from here and there and came up with this, maybe you can Now if I use this JQL - parent = test-52 ORDER BY rank DESC, i get this NOTE: if you omit the Order BY rank altogether you also get the ranked list. Irvine February 20, 2024 edited We have an issue hierarchy that uses 5 tiers (3 are in Jira Plans), in order as follows: Initiative, Feature Set, Feature, Epic, base-issues (and sub Thanks for your response. As an example the below would return all subtasks for a given project. But that subtask was last updated on Monday, and the rule last ran on Tuesday. Ask Question Asked 7 years, 4 months ago. I have looked at every community post online about fiiltering the parent in issuetype xyz, but nothing is working. fields. Type: Suggestion Resolution: Won't Fix Component/s: None Labels: None. I don't have A typical JQL query consists of the following components: Field: JQL fields represent different types of information, such as priority, fixVersion, or issue type. I have user stories in Jira with some labels A,B,C for example. - You can filter either parent issues or sub tasks. For example “type = subtask and parent status != done” is not a valid query and never will be (without scriptrunner) If you’re just trying to get the subtasks under a given issue you can simply use: “Parent = KEY-1” AND (some criteria) or for multiple issues: “Parent IN (key-1, key-2, key-3) AND (some criteria) JQL Functions; Included JQL Functions; Sub-tasks; Version Sub-tasks. subtasks. Your use case is more dynamic than that. But this would parent stories (or other issues in epic) epic (parent) linked issues JQL No parent/child relationship can be selected outside of task/subtask or epic/story. 2 answers 1 JQL parentIssuesOf() does not return parents . For example there is function "issueFunction in subtasksOf" which will return sub tasks based on parent task data . Answer. 8k 7 7 gold badges 68 68 silver JQL to display all the tasks and sub tasks of the parent Epic of the selected task or sub task . In my case it was something that returned any task or subtask matching a JQL expression, and also any subtask whose parent matched the expression (regardless if the subtask itself matches it or not). Advanced filter options will also give you all possible values to build Queries. I can Hello Community, Is there some way to show the fix version of the parent Epic on the issue level? We would like to show a list of issues ([Issue] Dimension) and for each one show the Fix Version of the parent Epic (assuming the epic is allocated to only one Fix Version). Hello, I am trying to pull a list of all subtasks of a specific type (we use 6 types of subtasks) across all projects in a specific time frame? My ultimate goal is to calculate average time from assigning a subtask to completing it, but I cannot seem to find a Hello, I want to create filters on my scrumboard to display the sub-tasks associated with US with labels. atlas Hi @Trudy Claspill I don't normally need to specify an issue type. But there's a free plugin that allows this. can you please have some suggestion on it about how to get - is there any function? Thanks, Keval We have a bunch of parent tickets, each of which may have several subtasks. December 1, 2022 . August 13, 2020 . Let's assume the trigger issue is a subtask, and so try adding: parent = {{triggerIssue. Currently it is setting the subtask due date as the created minus 14 days which is not what I want. How do I construct the JQL to return the count of Parent and Subtasks? Example: project=ABC and issuetype=Defect and status!=Closed-My count is 10 (and the list, of course) If you want to run your search dynamically, without manually "stitching" two queries together, you'll need extra tooling: You might be able to use Jira Automation to "propagate" parent information down to the children, and then use the respective field(s) on the children to include them into your filter. I do not want to use any plugins. Anyone? We code a function using the REST API (requires programming skills search for subtasks then get the parent id) periodically review the ondemand add-ons in the Jira marketplace for updated add-ons that extend JQL (I didn't seen any that do what you need) contact the Script Runner add-on owner and/or Jira and request this functionality. JQL (Jira): Issues containing Sub-tasks assigned to me . Ask Question Asked 3 years, 6 months ago. But you should have ScriptRunner plugin installed on your instance to use it. I'm trying to update the filter for my scrum board so that it will show subtasks only if the assignee on the subtask is different than the assignee on the main issue. Reply. Employee where Node = @h. hasSubtasks. g the issue view. I am using JIRA version v8. You must be a registered user to add a comment. I’m also looking for any place I can get a tutorial or information about the queries more generally. Anyhow will try this solution and see if I can come up with a JQL for the two subtasks only and move them to Blocked status. key I want to use Automation to set the status of a Task based on it's Sub-Tasks, I;ve got several sets of Subtasks all with a different prefix. What you want is this: issueType=<yourType> or issue in subtasksOf(issueType=<yourType>). I would like to have a filter per person on my daily. Finding a Top Level Parent in SQL. Otherwise, register and sign in. This JQL doesn't work in my case because it errors out when a standard issue is the trigger because {{issue. Is there a way to do it. Watch. Thanks! While I'm not sure of a way to retrieve the information you're looking for solely using the built-in JQL, the question has been asked before and an answer was accepted based on using a plug-in. Hi guys, I need to find a way to count the number of subtasks under an epic which are in To Do status. GitHub Gist: instantly share code, notes, and snippets. Here's a drawing to further explain my delima. Order by issuetype ASC. Cedacri. See examples listed here. That will not be possible with the native JQL capabilities. This way, you would need to create an filter that return the issues and it's sub-tasks an display them in the filter. as well as this expression: issues. ; Operator: Operators are the core of the query, relating the field to the value, JQL used : project = AM AND issuetype = Subtask AND Sprint = 83 I'm using this query but the result is empty even though there are many sub task for the current sprint . Database design for a list of task with subtask. Through the above JQL, you will retrieve all subtasks associated to that parent key. Can anyone please help here. Viewed 1k times 4 . 0. Closed; Activity. I've tried using the following: issueFunction not in hasLinks("child of") AND issueFunction not in hasLinks("parent of") But it still returns tasks, sub-tasks and issue with links (parent of or child of). Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically. · JRASERVER-18839 - Create a JQL funcionality to filter the sub-task for a field value of the parent issue (by Abner Luis Santos Rolim) · How to get subtasks of an EPIC in a filter query? Is there a way to extend this to get the root parent id of each id – Avin Kavish. Not necessarily SR4J, there might be some other cool add-ons, there are new add-ons coming up on the Marketplace, which you might be able use it for free. What is the JQL for issues with having parent status and issuetype as mentioned above I'm able to to that in the subtask structure, because I can use json and smart smart values to get all the subtasks of the parent ("issue. But when I use that JQL, it will look for Story issues in analysed with subtasks. Instead, the trigger should be either the 'issue JQL query of all cascaded child issues of a parent Cal. View More Comments. declare @h hierarchyid; select * from dbo. 2 - I have Sciptrunner and tried many JQL's but still not getting correct result. And the condition check would be {{lookupIssues. So you can get parent issues which have sub tasks meeting certain criteria, or you can get sub tasks whose parent issues meet certain criteria. Ask Question Asked 8 years, 8 months ago. I have the two queries sorted out: q1 I use the following advanced query to display parent issues of tasks assigned to me: issueFunction in parentsOf("status in (Open, 'In progress') AND project = MPONE AND assignee in (currentUser())") ORDER BY key ASC. Feature) that is under the top hierarchy issue (Initiative). I can confirm that to sum up the values on a subtask on a parent issue that we have the example script located in the documentation page here which provides an example of how to store the Get early access and see previews of new features. Now I need Community Leaders are connectors, ambassadors, and mentors. In the old view, the parent ticket path was visible at the top, In the example, I have attached. Thank you for the question. For ex. Replace ABC with your project and replace subtask with your exact subtask issue type This will get you the immediate manager of the id specified in @h. Viewed 3k times 3 . to see all the stories first, and then all the subtasks. December 2, 2024 . Add a comment | 2 Answers Sorted by: Reset to default 4 We can get these type of results by using the plugin JQL Search Extensions for Jira. IsDescendantOf(Node) = 1 With that last one, a node is considered a descendant of itself. Start Date}} action: lookup issues with JQL to find all Level 3 issues with the same parent as the trigger issue, ordered by the Due Date ascending; branch: on JQL for the latest Due Date, key = {{lookupIssues. In addition, i can get it in SQL+JQL but I need it in JQL only. For I'm trying to write a condition where all subtasks in an issue needs to be in done or canceled state, only then clone the issue. parent}} You must be a registered user to add a comment. I have tried just about every Action/Condition within my For Sub-tasks branch but nothing will clone the Subtask Status properly. Follow answered Feb 1, 2013 at 16:50. So I need to find subtasks with the same parent. I have a Kanban board that has swim lanes for each epic. Is there any way to do this? I Can get the particular sprint's information, but that's as far as I've gotten. Improve this answer. ). Is it possible to do so without ScriptRunner? But when I do a search all I can get back in the results are the parent issues. subtasks") and create the link. Although I have some doubts I'll come back to, you could try to modify your JQL to something like this: parent = {{triggerIssue. Cengiz Akyildiz. Story A X Y Z Story B Q R Th Is there any way to get a sum of the time spent on all of the sub-tasks and store that on the story? We use tshirt sizing for stories and my goal would be to build estimation reports based off of the average time a S, M, L, XL story takes. Comment; Like • Erin Liva likes this Get product advice from experts Ask a question → . The trigger for the automation should not be 'issue transitioned', as adding sub-tasks can happen at any time and is neither considered a workflow transition nor related to any transition. Personally I think you would have better chance of success trying to get this data from the SQL database directly instead of JQL. I'm using Jira cloud with ScriptRunner. Those subtasks should by in status analysed. key }} and type = "Dev-task" and then checks if some of them are in progress, or all are done respectively. If you have the key of the parent, in your case the task key, you could do something like this: issue in ChildrenOfIssuesInQuery("{parentKey}") I'm looking for a way to show sub-tasks grouped to their parent in e. I have following work items Issue, Defect, Story, Task, Feature and etc. I would prefer if we have a post function or conditi I need to get result of Task which are more than 10 hours of sum of all Subtask original estimate. The good news is the Craftforge JQL plug-in referenced is free. Hello @Bill Sheboy Actually I want to send a Create a filter for all of your subtask from the following JQL: in subtaskIssueTypes() and assignee = currentUser() Then, using Craftforge JQL Functions Plugin, use the following JQL to find their parents: issue in parentIssuesFromFilter("filter name or its id") Share. Closed. vjqgaiq adqgdy tqlcf wujdv elsegt yybl aonhtyl kuqqqj tgsy ohe