How to find sub-tasks that have the same assignee as the parent task?

Chris Solgat

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

Chris Solgat

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.