Issue List of Stories/Tasks with no sprint assigned but part of an epic with a target date assigned

[Steve Krummes]

I have a multi-layered query i am trying to figure out, I have gotten individual pieces to work but am struggling with putting it together.  

Our business operates at the epic level (business requests come to the team as epics).  The team is expected to assign a target date to a given epic once they pick it up and the target date is what our business partners are using to track when something is supposed to be done.

At the same time, the team works via sprints.  I am trying to pull a list of stories & tasks where those stories and issues are assigned to an epic that has a target date in the current month but where the story/issue is not assigned to a sprint.

Thanks in advance for any insight!

[Dick]

Hi @Steve Krummes Welcome to the Atlassian Community

When you use a scheduled automation, you are allowed to put in a JQL query. All the Jira items found in this query will be subjected to the remainder of the automation. 

So if that query were to find all epics that are due within a month, you can check each of these whether the children are on schedule. 

Kind regards,
Dick

[Vishal Biyani]

@Steve Krummes 

Using native JQLs you can't link Epic and standard issues in one query. You will need to use a multi-step process

• Identify the epic keys that match your due date criteria
• use parent in (<epic keys>) to identify standard issues (Story/Task) that are having sprint is Empty.

Otherwise, you will need to check some marketplace Apps