XPORTER custom template - dateformat issue

[Filip Zizka]

Hello,

probably i have a trivial question, but I would really appreciate your help.
For one of my excel field I used:
#{for comments}
#{if (%{'${Comments[n].AuthorFullName}'.equals('AuthorFullName')})}
${dateformat("dd-MM-yyyy"):Comments[n].Created}
#{end}
#{end}

,but this script doesn't work. I used same condition also for .Body and that works.

For this one I would like to export date when comment was created from specific person.

Note:
if I change dateformat to only MM-dd or dd-MM, than it works. Also found similar issue that if I want to export english-UK format than the whole JIRA language has to be setup in english-UK, but I already have my JIRA in english-UK and am also not abel to export US dateformat as well.

There is comment body script which is working fine.
#{for comments}
#{if (%{'${Comments[n].AuthorFullName}'.equals('AuthorFullName')})}
${Comments[n].Body}
#{end}
#{end}

Thank you in advance.
Filip

[Levente Szabo _Midori_]

Hi @Filip Zizka 

I'm sure the team behind the app would be the best source for a reply. While you wait for a response, let me mention that Better Excel Exporter comes with a default template for handling and exporting comments that doesn't require any script modification or template customization.

It automatically exports the comment author, comment date, and comment body in Excel. You can filter it for a specific user and (in case of Jira Service Management) even decide if you want to leave internal comments out (greyed in the below sample export).

Here is an article + video about how simple it is and see an example export below.

(Please note that I'm part of the team developing Better Excel Exporter.)