Description in the JIRA Import

Questions & Answers
,
21

Thanks a lot Gerda for your insights. The trick with issues worked for me

Sadly, I work within a very restrictive environment so my options are limited. an Addon might take months to approve.

One last advise, please. In order to extract just the values after | in this multi-line field, I was thinking of using some sort of a substring function with indexof.

something similar to substring ([Issue Business Justification], Indexof('Priority | ') + 11 , Index of(‘Project |’)

I know it might not be clean, but is that attainable?

22

I think I managed to do it using this expression. A bit of detour though.

CASE WHEN
[Measures].[Issue Business Justification]>""
THEN

ExtractString
(

CoalesceEmpty(Replace([Measures].[Issue Business Justification],CHR(13), “fini”),"")

,

‘.Priority |(.+)fini.’,1

)
END

1 Like
23

@mmawla you can try also this formula:

CASE WHEN
NOT IsEmpty([Measures].[Issue Business Justification])
THEN
Replace(
ExtractString(
  [Measures].[Issue Business Justification],
  '(Priority|\\n) (.*)',
    2),
    "| ", 
    "")
END

See related documentation on other ExtractString() examples

1 Like
25

Hi @guy.winterbotham ,
I wanted to let you know that we have released eazyBI version 7.1. recently. In this version, we included the feature to allow importing the Jira “Description” field using the New calculated fields option. In the eazyBI account, it is possible to use those settings to define and import the description field. The JavaScript code is: return issue.fields.description

eazyBI_field_description
eazyBI_field_description1390×1112 128 KB

Please see a list of all changes for eazyBI for Jira app: Changelog - eazyBI for Jira.

Kind regards,
Gerda // support@eazybi.com