Jira Exporter Function fullname is not displaying names for Multi-User Picker field

[Michael Suder]

I am using the following syntax in my exporter template file BUT no names of users are being displayed when I use the template for export:

${fullname:Approvers}

My field name is "Approvers" and this has been confirmed by inspecting the XML for the issue.

in contrast, this does work to output the display name of the issue Assignee:

${AssigneeUserDisplayName}

[Marshall Walker Lee]

You're encountering a common syntax difference between various Jira exporter tools. While ${AssigneeUserDisplayName} works for a system field like 'Assignee', custom fields, especially those that can hold multiple users like your "Approvers" field, often require a different approach depending on the specific exporter add-on you are using.

The syntax ${fullname:Approvers} is the correct format for the Xporter for Jira add-on. If you are using Xporter, the issue might stem from a few other possibilities:

• Field Type: Double-check that "Approvers" is indeed a "User Picker (multiple users)" or "User Picker (single user)" field.
• Data in the Field: Ensure that the "Approvers" field in the specific issues you are exporting actually has users selected. An empty field will, of course, produce no output.
• Exporter Caching: In some rare instances, caching within the exporter template can cause issues. Try making a minor edit to your template (like adding a space) and re-uploading it.

Syntax for Other Popular Exporter Add-ons

If you are not using Xporter, the syntax will be different. Here are the common syntaxes for other popular Jira exporter add-ons:

• Better Excel Exporter: This add-on often uses Groovy expressions. To get the display name of users in a custom field, you would typically iterate through the list of user objects.

  For a single user picker:

  ${issue.get("Approvers")?.displayName}
  

  For a multi-user picker, you'll need to loop through the users:

  XML

  <#list issue.get("Approvers") as user>${user.displayName}<#if user_has_next>, </#if></#list>
  

  This example iterates through the list of approvers and prints their display names, separated by a comma.

• Jira's built-in CSV export: Jira's native CSV export has limited capabilities for formatting custom fields and typically exports the username rather than the full display name for user picker fields.

[Michael Suder]

Marshall,  I am using the Xporter for Jira add-on.

I have confirmed the following:

Field Type:  Field is a User Picker (multiple users)
Data in the Field: There are 2 names in the field
Exporter Caching: I have edited the template many times and still no data

[Michael Suder]

Also of note, when I choose to use the Jira OOTB Export to Word, the 2 names in the "Approvers" field are in fact rendered in the output.

[Michael Suder]

Marshall,  Here is a snippet of the XML Export:

<customfield id="customfield_20003" key="com.atlassian.jira.plugin.system.customfieldtypes:multiuserpicker">

<customfieldname>Approvers</customfieldname>

<customfieldvalues>

<customfieldvalue displayname="John Smith">

<![CDATA[ john.smith@xx.gov ]]>

</customfieldvalue>

<customfieldvalue displayname="Jane Doe">

<![CDATA[ jane.doe@xx.gov ]]>

</customfieldvalue>

</customfieldvalues>

</customfield>