You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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.