nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use script JQL function with regex in groovy script

SWAPNIL SRIVASTAV

When I am using '$' sign in groovy script for behaviour in jira, I am getting compliation error.

Objective: Trying to validate summary field. Not allowing duplicate summaries. Searching the exact text in summary and making it case-insensitive search.

JQL query which is working fine in Issue Navigator:

issueFunction in issueFieldMatch("project = "ABC and key !=AB-1", "Summary", "^(?i)Test$")

Script I tried:

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.issue.searchSearchProvider

import com.atlassian.jira.jql.parser.JqlQueryParser

import com.atlassian.jira.web.bean.PagerFilter

import com.atlassian.jira.issue.Issue

def summaryObj = getFieldById(getFieldChanged())

def summary = summaryObj.getValue()

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)

def searchProvider = ComponentAccessor.getComponent(SearchProvider)

def issue = underlyingIssue

if(issue == null)

{

return

}

def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

def query = jqlQueryParser.parseQuery("issueFunction in issueFieldMatch('project = Cluster and key!= "+issue.key+"', 'Summary', '^(?i)"+summary+"$')")

if(results.getTotal()>0)

{

summaryObj.setError("Issue Summary already exists.")

}

else

{

summaryObj.clearError()

}

I am getting error in the line I have made bold as Illegal String Body character after $ sign. I think it is because groovy performs String Interpolation also using $ sign. How to get the JQL accepted in this script?

Kindly help.

Thanks and Regards,

Swapnil Srivastav

Accepted answers

Damian Wodzinski_ayk1y7

Use \ before any character that can be interpreted improperly. So it would be:

def query = jqlQueryParser.parseQuery("issueFunction in issueFieldMatch('project = Cluster and key!= \"+issue.key+\"', 'Summary', '^(?i)\"+summary+\"\$')")

I do not know if you need to do it before ' characters, you need to check that.

I made similar one:

def query = jqlQueryParser.parseQuery("issueFunction in commented(\"by ${person} after startOfDay(-1d) before endOfDay(-1d)\") AND project = \"PCS\"");

All comments

Damian Wodzinski_ayk1y7

def query = jqlQueryParser.parseQuery("issueFunction in commented(\"by ${person} after startOfDay(-1d) before endOfDay(-1d)\") AND project = \"PCS\"");