Function query specific story / subtasks

[Philippe Artaud]

Hello Community, 

I'm trying to find how to filter : 

All story with specific Label "Toto" that have a due date  > today + 6months ; and all their related subtasks if they have : 

- No Due date set-up or Due date > today + 6months

No need to display the Story if no subtasks meet the criterias.

Any help :)

Thanks a lot

Philippe

[Jack Brickey]

this is a rather complex query and will require an addon like Scriptrunner or similar. Do you have such an addon?

[Philippe Artaud]

I'm trying this but didn't give me exactly what i'm expecting : 

issueFunction in subtasksOf("project = \"BSC Technical Debt 2020\"  and labels = RACI_BSC and issuetype = Story  and duedate < endOfDay(180) ") AND status != Closed AND status != "To Validate" AND labels = FPM OR issueFunction in parentsOf(" Labels = FPM AND labels = RACI_BSC AND issuetype = Sub-task AND (status != \"To Validate\" and status != Closed  ) AND (labels = Critique OR Labels = Vitale) ") AND duedate < endOfDay(180)