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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,464,112
Community Members
 
Community Events
176
Community Groups

Converting full name to user id for use in reporter field

Edited

Hello. I am quite new to Jira automation, so excuse my limited knowledge.

I am setting up automation for our new hire tickets. These are created from emails sent from our HR tool. I am setting up automation that will set the new hire's Line Manager as the Reporter.

Since the description is just text in an email, I need to do a match for the name, however, the reporter field will not work with full names, and expects userid, username or email, as far as I can gather.

Is there some way for the automation to do a search for full names and tie it in with userid, so this can be populated in the Reporter field?

Using the match command seems to work, but the automation rule gives an error saying the user does not exist, even though the Name is unique and a 100% match of the users Display Name.

This is the info included in the Description from the email.

 An employee has been hired.

Employee Id: 12345
First name: Firstname
Last name: Lastname
Organizational Relationship: Employee
Department: 123456 Sales Europe
Location: Amsterdam, The Netherlands
Reports to: ManagerName ManagerSurname 
Hire date: 2022 09 01

I have tried using this code, but the user picker does not like it.

{{issue.description.match("Reports to:\s(.*)")}}

I assume this has to be done in a few steps, but is this even possible?

Thank you for reading.

1 answer

0 votes
Carlos Faddul Community Leader Jul 25, 2022

Hi @Marius Skoglund 

To performed something like this, you will need to split the pattern that you got from this

{{issue.description.match("Reports to:\s(.*)")}}

To this

{{{{issue.description.match("Reports to:\s(.*)").split(" ").last}}}}

Or if you want you can create variables in automation to deal with the values more easier.

I assumed the pattern being "FullName Username"

Captura de tela 2022-07-25 230122.png

Then assignee the value that you need with the functions to treat your text.

 Captura de tela 2022-07-25 230337.png

I hope I helped you.

If this post was helpful, mark it as Accepted Accepted, so you can help others who may have the same difficulties.

If your question has not been resolved, please post again with more details.

Thank you for the response. The reporter field does still not like the output, this is from the log:

 

Error editing issues
ITOFC-17 (The reporter specified is not a user. (reporter))
Carlos Faddul Community Leader Aug 01, 2022

@Marius Skoglund does managerSuername have any active users?
You can test with a user like yours for testing purposes.

Thanks. Yes, all Managers are active users in the system, and are manually set as reporter for the tickets. Manually, it works, but with the automation, it fails, even though the name matches the users display name.

Carlos Faddul Community Leader Aug 10, 2022

@Marius Skoglund , is there any log of error of automation ?

If manually, it works, maybe schedule can trigger corectly.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events