I want to remove the unassigned subtasks and completed subtask in the following query

[Devi Gattu]

cf[11101] = 2290 AND issue in childIssuesOf(RMGPOO-14259) OR issue in childIssuesOf(RMGPOO-14403) OR issue in childIssuesOf(RMGPOO-14404) OR issue in childIssuesOf(RMGPOO-14406) OR issue in childIssuesOf(RMGPOO-14419) OR issue in childIssuesOf(RMGPOO-16514) AND issue not in childIssuesOf(RMGPOO-16337) AND cf[11101] = 2290

[Trudy Claspill]

Hello @Devi Gattu 

Welcome to the Atlassian community.

Please provide more information about what you are trying to do.

Are you trying to change the filter so that the results won't include unassigned sub-tasks?

When you say you want to "complete" the subtasks do you mean you want to transition them to a specific Status?

[Devi Gattu]

Hi Trudy Claspill,

Thanks for responding!

I want to fetch the child issues (stories and subtasks )of above mentioned epics but there are issues like completed subtasks and stories, unassigned stories and unassigned subtasks and also every issue should have filed cf(11101)= 2290 as well so I want final out like 

The query should exclude the unassigned and completed subtasks only .

Thanks

Devi G

[Trudy Claspill]

Try this filter. If it doesn't get you the results you want, let us know exactly what is wrong with the results. If an issue is included that you think should be excluded, tell us what attribute of the issue makes you think it should be excluded. If an issue is missing that you think should be included, tell us about all the attributes (status, issue type, assignee, custom field, and parent Epic to which it belongs) that make you believe it should be included.

cf[11101] = 2290 AND 
(issuetype != Sub-task and status != Complete AND assignee is not EMPTY) AND
(issue in childIssuesOf(RMGPOO-14259) OR 
issue in childIssuesOf(RMGPOO-14403) OR 
issue in childIssuesOf(RMGPOO-14404) OR 
issue in childIssuesOf(RMGPOO-14406) OR 
issue in childIssuesOf(RMGPOO-14419) OR 
issue in childIssuesOf(RMGPOO-16514) )