Function query specific story / subtasks

Question

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

Philippe Artaud · Answer

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)

Jack Brickey · Answer

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