Filter considering only special projects out of source data

Questions & Answers
1

Hi all,

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?

Generate(
– get a list of block issues not in Done status
Filter(
[Issue].[Issue].GetMembersByKeys([Issue].CurrentHierarchyMember.get(‘FeatureLink’)),
[Measures].[Issue fix versions] MATCHES “.PI21.4_Implemented.”),
– show those issues by key
cast([Issue].CurrentHierarchyMember.Key as string), “,”
)

2

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:

[Issue].CurrentHierarchyMember.Get('Project key')

best,
Gerda // support@eazyBI.com

3

Hi Gerda,
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?
Michael

4

Hi @Michael
If I understand your requirements then this is how you can add an additional filter to your measure:

Generate(
-- get a list of block issues not in Done status
Filter(
[Issue].[Issue].GetMembersByKeys([Issue].CurrentHierarchyMember.get('FeatureLink')),
[Measures].[Issue fix versions] MATCHES ".PI21.4_Implemented."
AND
[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.

best,
Gerda