Jira story description with table

rajvr

I have a table in story description like below. I want to search the description with specific field and get the value. I tried with Match function but not able to achieve it.

Expected:

1. When string matches "ABC" then I want output as 1,2,3

2. When string matches "DEF" then I want output as 2 AM

3. When string matches "GHI" then i want string as 3 AM

Can you help me with solution

|ABC|1,2,3| |DEF|2 AM| |GHI|3 AM|

 

Bill Sheboy

Hi @rajvr -- Welcome to the Atlassian Community!

You appear to be asking a question about an automation rule.  Is that correct?

If so, please note context is important for the community to help.  Please post the following:

• what type of project is this (e.g., company-managed, team-managed, etc.), 
• an image of your complete automation rule in a single image for continuity,
• images of any relevant actions / conditions / branches,
• an image of the audit log details showing the rule execution, and
• explain what is not working as expected and why you believe that to be the case.

Until we see those...

 

Let's assume you only have a single table (with markup) in your Description field.  If that was written to the rules audit log directly, it would look like this, assuming there is a header row:

||*my key*||*my value*|| |ABC|1,2,3| |DEF|2 AM| |GHI|3 AM|

Where the rows have a newline between each one.  That information may be used with the split() function, creating a list of the rows, enabling the match() function to parse them one by one.  For this scenario, the pipe | characters need to be escaped in the regular expression passed to the match().

 

For example, to get the "value" for the row with a "key" of ABC, that expression could be this:

{{issue.description.split("\n").match("\|ABC\|(.*)\|")}}

Please update the regular expression based on the actual column structure, especially when there are header rows / columns.

 

Kind regards,
Bill