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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Extract strings from table in description and assign to fields

Edited

Hi,

I have a table in Description with several rows as you can see below. I want to:

1. Extract value against Space Key - "nyleseries2" in the example and add it as a label to the issue. Space Key can be between 5-30 characters but always one string.


2. Extract value against Wiki Login in the Description field- and if the user exists in JIRA users, assign the value to Reporter field so that the user gets notified, else, skip assigning. The Wiki Login value can be what a generic email address can go for 12-40 characters I think?

I have the following value table in the description field:

 

KTF Tech Documentation Feedback

You are receiving this notification because documentation feedback has been submitted.

 

Feedback Details

 

Company

KTF Tech

Name

John Doe

Wiki Login

johndoe@ktftech.com

Space Name

Nyle Series 2.0

SpaceKey

nyleseries2

Page

Getting Started

Satisfaction Score

7

Was Document Helpful

Yes
Reason for ScoreAll Good

How to Improve

Please consider adding more videos maybe?

Feedback Type

ONLINE

Allow to Contact

Yes

Jira issue submitted

Yes
  

 

In Text View of teh JIRA Description field, the table appears in Wiki markup syntax like this:

 

h2. {color:#ff0000}KTF Tech Documentation Feedback{color}

{color:#000000}You are receiving this notification because documentation feedback has been submitted.{color}
|h4. {color:#993300} Feedback Details{color}|h4. |
|h4. Company|KTF Tech|
|h4. Name|John Doe|
|h4. Wiki Login|johndoe@ktftech.com|
|h4. Space Name|Nyle Series 2.0|
|h4. SpaceKey|nyleseries2|
|h4. Page|[Getting Started|https://conf.ktftech.com/nyleseries2/getting-started]|
|h4. Satisifcation Score|7|
|h4. Was Document Helpful|Yes|
|h4. Reason for Score|I found what I was looking for. Great info on this page.|
|h4. How to Improve|Please consider adding more videos maybe?|
|h4. Feedback Type|ONLINE|
|h4. Allow to Contact|Yes|
|h4. Jira issue submitted|Yes|

 

I have checked several resources and it seems I need to use match function and maybe something else to extract the required strings and assign. Can anyone please help?

 

When I try passing this value to Labels: {{issue.description.match(".*\|SpaceKey\|(\w+)\|.*")}}, I get error.

My Rule setup:

rule.png

 

My Audit log:

log.png

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

97 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you