my Jira source data includes several projects. In the following code I read out the links of my source data. Now I want to extend the code so that only special projects are considered, e.g. Project1 and Project2 (source data contains much more projects). Could you please help to modify the code?
– get a list of block issues not in Done status
[Measures].[Issue fix versions] MATCHES “.PI21.4_Implemented.”),
– show those issues by key
cast([Issue].CurrentHierarchyMember.Key as string), “,”
Hi @Michael ,
If you need to get the issue project key, then starting with eazyBI version 6.2.2 you can use property “Project key”.
To get it you can use this formula:
Gerda // support@eazyBI.com
thanks for your support. I did not get it. I want to filter only results from a special Jira Project. How do I have to insert your formula into the code?
If I understand your requirements then this is how you can add an additional filter to your measure:
-- get a list of block issues not in Done status
[Measures].[Issue fix versions] MATCHES ".PI21.4_Implemented."
[Issue].CurrentHierarchyMember.Get('Project key') MATCHES "ABC||CDE")
-- show those issues by key
cast([Issue].CurrentHierarchyMember.Key as string), ","
If this is not what you are looking for, please provide a more detailed example of your use case.