How to get a list of portal users with custom columns/details

[Kel Hill]

I want to be able to export creators of service management issues (support tickets) within a specified date range, showing their name separately from their email address. We need this to upload into a different system from which we issue bulletins to our users.

Curently, if I create a filter that includes the Reporter column, it shows EITHER their name if the full name has been entered into the system, OR shows their email address when the full name is missing. Both their name and their email address is required in two separate columns.

I also tried the export feature, which does show both a name column and an email address column, but it does not show when they last created an issue. Ideally, this existing export should allow me to select what columns I want included in the query, as we also want to include our custom field for Customer Account name.

Alternately, is there any JQL command in filters that can force the Reporter column to show the email address field rather than the full name that has been entered?

[Jack Brickey · Accepted solution]

Hi @Kel Hill , unless you can somehow capture the user's email in a field, you will be unable to export it using a JQL filter. In other words, a JQL filter operates on issues and fields. User fields will only have the username. However, as you have pointed out there are cases where the email itself is the user name. An alternative solution would be too export the users from admin > user management in addition to exporting the issues and then use excel to perform lookups and populate a cell with the email matching the user name.