Jira Automation: Count how many times a specific set of numbers are in a paragraph custom field

Philip Ng_rkxzy7

I am using a Jira Issue for a bug that records the client ids that have reported the issue in a custom paragraph field. If a client reports the issue multiple times, their client id will show up multiple times. 

I am trying to setup an automation where if you manually trigger the automation, it prompts you to enter the client id number you are looking up. Then I want it to count the number of times that user entered client id appears in that paragraph custom field and export that number to another custom field.

I can setup the prompt but when it goes to return the count, there is no calculated response.

This is the automation I setup:

{{issue.customfield_11371.match(userInputs.searchcounter).size}} times

 

 

Example:

Customfield_11371 contains this data:

1234

7499

2468

6654

7499

 

I trigger the automation and enter 7499 but no response but the word "times:" appear I'm looking for it to enter 2 times into the new custom field.

 

Can someone assist me in telling me what I am doing wrong? Thank you

 

Bill Sheboy

Hi @Philip Ng 

Your rule is trying the user input field in the match() function but it is not in the correct format for the function's use of regular expressions.  To solve this, first create a variable which wraps the input in parentheses and then uses that variable in the function.

• trigger: manual input, with the user input, and assuming it is a required field
• action: create variable
  • name: varRegEx
  • value: ({{userInputs.searchcounter}})
• action: log, to check the result
  • {{issue.description.replace("\n", " ").split(" ").match(varRegEx).size}} times

 

The match() function does not support adding content from smart values and so this technique allows creating a dynamic regular expression.

 

Kind regards,
Bill