Issues that Blocks other issues

Questions & Answers
,
1

Hi guys

I would like to create a dependencies view table to show issues that is blocked by other issues from other projects. For instance: Issue XPTO from project Alfa is blocked by [issue A][Project Beta],[Issue B][Project Gama]

This view need to exclude issues from same project

Is this possible? If yes, how can i create this?

Until now i can only created a view where it’s showed all issues that is blocked

I trys this, but it didn´t works:

– annotations.group = 4 Issue links and hierarchies
Generate(
Filter(
– get a list of linked issues
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Is Blocked’)
),

–filter condition: include only issues from a different project
[Issue].CurrentHierarchyMember.Get(‘Project key’) <>
ExtractString(
[Is Blocked].CurrentHierarchyMember.GetCaption,
–return the first word
“^\w+”)
),

– show by key
“[” || cast([Issue].CurrentHierarchyMember.Name as string) || “ - " || [Status].[Status].getMemberNameByKey([Issue].CurrentHierarchyMember.Get(‘Status ID’)) ||”]
"
)

5 Likes
2

Hi @Diego_Marcos_Ribeiro ,

Please check if the following expression might work for you.

-- annotations.group = 4 Issue links and hierarchies
Generate(
--save current project in separare dimension
 [Project].[Project].GetMemberByKey(
   [Issue].CurrentMember.Get('Project key')),
--generate the text for the only project
   Generate(
    Filter(
    -- get a list of linked issues
    [Issue].[Issue].GetMembersByKeys(
     [Issue].CurrentHierarchyMember.get("Is Blocked")
    ),
    --filter condition: include only issues from a different project
    [Issue].CurrentMember.Get('Project key') <>
    [Project].CurrentMember.Get('DISPLAY_KEY')
    ),
    -- show by key
    "[" || cast([Issue].CurrentMember.Name as string) || " - " ||
    [Status].[Status].getMemberNameByKey([Issue].CurrentMember.Get('Status ID')) ||"]",
--split by comma if multiple
    ","
    ),
--split by new comma for compatibility
   ",")

regards,
Oskars / support@eazyBI.com