Hello, I'm trying to create an Increment advanced roadmap from Top of our hierarchy to story level. We have multiple projects to gather the data from so have created a filter to connect to when creating my plan:
Example:
issuetype in (Initiative, Epic, Story) AND project in XXXX AND ((due >= 2022-08-01 AND due <= 2022-11-30) OR ("Start date[Date]" <= 2022-08-01 AND due >= 2022-11-30) OR ("Start date[Date]" >= 2022-08-01 AND "Start date[Date]" <= 2022-11-30)) ORDER BY key ASC, created DESC
Reason for filter is to ONLY give a 12 week increment view however, it seems stories are not pulling through on the plan.
We could create a plan against ALL projects however this doesn't give you a clean increment view of just 12 week (even if you customer the gnatt range)
issuetype in (Initiative, Epic, Story) AND project in XXXX
This should be project in (list of projects) AND ....
and this part "OR ("Start date[Date]" <=" is an entirely separate query, so you're going to et all issues that were created in that range regardless of issuetype. You can add the issuetype in (list) into the 2nd part of the query, after the OR, to narrow it down more.
Every "OR" is a new query, so you'll often need to repeat parts of the query a few times.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.