How to Add and exclude Stories based on Qurries

[Yasir Masood]

Hi,

In confluence, we are managing stories list as per the release. We have to include the Stories list for each release. Based on the status, it is required to exclude those stories from the list if don't meet certain criteria e.g.

 four stories: ABC-1101, ABC-1102, ABC-1103, ABC-1104 have include for next release. All these stories are in development stage. Want to exclude any of the above release after a certain date if not in a QA status.

We are doing it manually which is a hassle so keep track by using Excel.

So my questions:

 1- Is it possible to automate the process using query? if yes then how?

2- Is it possible to synchronize Excel with Confluence page to have accurate list of queries in both environment?

Thanks

Yasir

[Fabio Racobaldo _Herzum_]

Hi @Yasir Masood ,

you can use clause issuekey nt in (ABC-1101, ABC-1102, ABC-1103, ABC-1104) in your jql.

Hope his helps,

Fabio