How to get a CustomField Value from a Linked Issue

Questions & Answers
, ,
21

Hi @martins.vanags ,

If I take your code as it is I get the error message:
Formula is not valid:
No function matches signature ‘Order(, , , )’

If I take without “–Generate(” and "–[Fix Version].CurrentHierarchyMember.Name, ", “”
CASE
WHEN [Measures].[Issue type]=“Concept Deliverable”
THEN
Generate(
Order(
Filter([Fix Version].[Version].Members,
[Measures].[Issues created]>0 AND
[Fix Version].CurrentHierarchyMember.Name <> “(no version)” AND
[Fix Version].CurrentHierarchyMember.Name <> “unspecified”
),
[Fix Version].CurrentHierarchyMember.getDate(‘Release date’),
BASC,
[Fix Version].CurrentHierarchyMember.Name, ", "
).item(0).getCaption
ELSE [Measures].[Issue fix Versions]
END

I get
Formula is not valid:
Syntax error at line 15, column 1, token ‘ELSE’

I cannot see why.

22

I updated the code (removed commented lines which were formatted incorrectly) and update the ELSE branch with Cast (as string) function to force the specific format for the “ELSE” validation.

Martins / eazyBI

23

It doesn’t work :frowning: I get the error message:
Formula is not valid:
No function matches signature ‘Order(, , , )’

24

Hi,

Try the updated code now.

CASE
WHEN [Measures].[Issue type]="Concept Deliverable"
THEN
Order(
Filter([Fix Version].[Version].Members,
[Measures].[Issues created]>0 AND
[Fix Version].CurrentHierarchyMember.Name <> "(no version)" AND
[Fix Version].CurrentHierarchyMember.Name <> "unspecified"
), 
[Fix Version].CurrentHierarchyMember.getDate('Release date'),
BASC
).item(0).getCaption
ELSE cast([Measures].[Issue fix Versions] as string)
END

Martins

1 Like
25

It seems that this works. Thank you very much.
But I have one smaller issue now. I get “#null” for some issues. Do you know why? How can I hide “#null”

26

@Christine
Maybe you can put an extra validation at the beginning

CASE WHEN
[Measures].[Issue type]=“Concept Deliverable”
AND
[Measures].[Issues created]>0
THEN…
END

Null is for empty combinations in your report.

Martins