Retrieving passed fixversion

gerda.grantina · November 7, 2022, 10:01am

When I try to try the JQL part “fixVersion < “current fixVersion”” my Jira doesn’t recognize this type of query. Do you have some 3rd party app for it? Or do you have some Jira fields for the current version? As I checked the Atlassian documentation and couldn’t find this. I need this information to understand how to define the same in eazyBI.

You mentioned that for projects A and B, you have different actual version release dates. There is an option to generate a list of versions before the dates that are defined in the MDX formula for each project, in my case DA and DB projects.

Generate(
  Filter([Fix Version].[Version].Members,
   ([Measures].[Issues created], 
   [Time].CurrentHierarchy.DefaultMember) > 0
   AND
   -- if Project is DA and release before 
   (([Fix Version].CurrentHierarchyMember.Get('PARENT_KEY') = 'DA'
   AND
   DateBeforePeriodEnd([Measures].[Version release date],
   [Time].[Day].DateMember('Dec 31 2021')))
   OR
   -- if Project is DB and release before 
   ([Fix Version].CurrentHierarchyMember.Get('PARENT_KEY') = 'DB'
   AND
   DateBeforePeriodEnd([Measures].[Version release date],
   [Time].[Day].DateMember('Apr 30 2020'))))
  ),
  [Fix Version].CurrentHierarchyMember.Name,
  ","
)

In the report:

best,
Gerda