Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

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?

1 answer

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Sep 28, 2023

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.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events