Automation Extraction Issues

[JayJuan Jones]

Hello,

I have some issues with my new automation that I am setting up to extract the values of my fields from the description of my issues that are raised via email. I have some automation in place to extract the issue.desccription of any particular issue in order to get it to show the way that the text is formatted, as you can see below:

the fields that I am currently trying to extract are myColorado Username, OS Version, and Phone Model.

The automation that I have set up does not seem to be pulling these in for whatever reason and one of the errors that I get even mentions fields with the same name. Any idea what could be going wrong here?

[Kiel Frost]

Hi @JayJuan Jones 

I was able to confirm that I can update a field based on a similar condition using the match function on {{issue.description}}

Example:

I extracted the "username123" from the description and updated the "My Test Customfield" field.

Below is the regex I used to extract the username from the description field.

I have two suggestions for you to try

1. To help debug use "Log Action" to debug your rule - Learn about Debugging your rules \

2. Make sure your Regex is returning the right value by utilising a tool such as an online regex tool 

Hope this helps.

[JayJuan Jones]

I tried that and still no luck! I see that it said successful, but it is not updating the field I expected. Does this look correct:

[Yanty Ghani [ServiceRocket]]

Hi @JayJuan Jones ,

Perhaps you can try using this:

{{issue.description.substringBetween("myColorado Username|","||OS Version")}}

 Hope that works.

[JayJuan Jones]

still no luck, it's saying its successful just like mines was, but it's not updating the field, even though it's saying it edited the issue

[Yanty Ghani [ServiceRocket]]

I think it's because in your "Description", there's a space between the parallel bars. So the text should be this:

{{issue.description.substringBetween("myColorado Username|","| |OS Version")}}

[JayJuan Jones]

so, in the line above are you trying to pull the myColorado Username or the OS Version? I only want to pull one value at a time.

After making that update, I am still getting the same outcome. A success, but no values have actually been updated. 

Here is the output again just in case it might help:

[Yanty Ghani [ServiceRocket]]

It's hard to get the actual text in your "Description" field, but I tried this in my issue and I managed to extract the info:

And here's the automation I used:

That "substringBetween" means that it will get the text in between those strings.

Also, please make sure that your custom fields, "myColorado Username" and the others are "Text" field type.

[JayJuan Jones]

still no luck! all my fields are text fields and I have updated the automation to match exactly what you have. Any ideas what I am doing wrong here or why its not working? Any typos you notice:

[Yanty Ghani [ServiceRocket]]

Why are you using "\OS Version" instead of "| |OS Version"?

[JayJuan Jones]

oops, updated it and still no luck! this is so frustrating and weird. It's saying success, but not actually updating!

[Yanty Ghani [ServiceRocket]]

Under that "Add value to the audit log", can you change it from {{issue.description}} to {{issue.description.substringBetween("myColorado Username|","| |OS Version")}}

Then you can check the audit log to see what's the value for that substringBetween.

[JayJuan Jones]

great idea! it's returning a blank value

[Yanty Ghani [ServiceRocket]]

Ok, so now you can just experiment with it, until you get the value you need.

[JayJuan Jones]

that didn't help, I still have not been able to return anything. 

[JayJuan Jones]

why is it working for you, but not for me?

[Yanty Ghani [ServiceRocket]]

The best thing for you to do is log a ticket with Atlassian Support, https://support.atlassian.com. They would be able to log to your Jira Cloud and see what the real issue is.

[JayJuan Jones]

thanks, I just did!