Is there a way I can create a filter out a set of epics and the stories (with their status)

[kalai arasi Murugesan]

Is it possible to have an intutive Jira filter in confluence, that lists all the epics scoped for a release , the associated stories and the status of the respective stories ..all in one ?

Thank you in advance. 

[Trudy Claspill]

Hello @kalai arasi Murugesan 

Welcome to the Atlassian community.

You can use in Confluence any query that you can construct in Jira directly.

Are you using Jira Cloud or Jira Server/Data Center?

What is your definition for "epics scoped for a release"? What piece of data do you have in the Epic issues that indicates it is scoped for a particular release? Are you using Fix Version? If so, do you set the Fix Version on the associated Stories also?

If you are using Fix Version and setting the field in both the Epics and the associated stories, then a filter like this will give you the list of all issues that have a particular Fix Version value:

fixVersion=<version name>

Reference: https://support.atlassian.com/jira-software-cloud/docs/jql-fields/

In Confluence you can use a Jira macro to display a list of Jira issues.

https://support.atlassian.com/confluence-cloud/docs/insert-the-jira-issues-macro/

Note that the folks viewing the information in Confluence will also have to have permission to see that information within Jira itself. If they don't have Jira permissions, then they will not see the Jira information in Confluence either.