I have a team that is looking for a filter that will return specific sub-tasks of a parent task that have been completed. The problem that I have run into is that the assignee of the sub-task needs to match the parent task. Also, I need this to display a list of all of the assignees, not just a specific one. There are over 400 individual assignees, and the manager wants to see the results as a list. Here is what I have so far and it gets me about 80%.
project = oei AND issueFunction in subtasksOf("project = oei and status = open") AND "OE Component" in (cascadeOption(Education, "Lean Leader"), cascadeOption(Education, "Lean Introduction (2 days)"), cascadeOption(Education, "Innovation Awareness (2 days)"), cascadeOption(Exposure))
This is what I found when querying the database directly.
select j.id, j.issuenum, j.PROJECT, j.ASSIGNEE, j.SUMMARY, j.issuestatus from jiraissue j, issuelink l where j.ID = l.DESTINATION and j.PROJECT = 10500 and j.resolution is not null and j.ASSIGNEE is not null and l.SOURCE in (select j2.id from jiraissue j2 where j2.issuetype = 14 and j2.RESOLUTION is null and j2.ASSIGNEE is not null) and j.id in (select cfv.ISSUE from customfieldvalue cfv where exists (select * from customfieldoption cfo where cfo.ID in (11118, 11121, 11122, 11123, 11125, 11132, 17201) and cfv.Stringvalue = cfo.ID) and cfv.CUSTOMFIELD = 11004)
I need to see if this can happen in JQL and saved as a filter so that it can be used as a dashboard.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG