Hi Swapnil,
I see that you are using the scriptrunner plugin for Jira, and trying to use the issueFieldExactMatch JQL scripted function, but this is not behaving as you expect. The link you cited though is a very old version of the documentation for that plugin, please see an updated version over at https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issuefieldexactmatch
From that page:
Previously it was incorrectly documented that it was for an exact regex match, and may have even behaved like that. This was a bug.
Because this function had this previous bug, there are a number of misconceptions over its intended behavior vs actual behavior. Because of that I think would be preferable to use the other function, issueFieldMatch() instead and still get back the results you want here (ie case insensitivity). I think we can overcome the problems you mentioned previously here with that function. Try this query instead:
issueFunction in issueFieldMatch('project=ABC and type=DE','Summary','[Ff][Gg][Hh]\\b')
This is one way to search for the word 'fgh' and 'FGH' (as well as 'FgH' among others). The use of the \b makes this a word boundary search, so it won't include anything strings that might go beyond such as 'fghijk'. For use in JQL searching we have to double escape the slash here though into '\\b' or else JQL won't accept it.
That said the better approach here is to tell the scriptrunner regex parser to turn off the case-sensitivity rather than brute force all the combinations. We can do that by starting our regex with the switch of (?i). So you can make another query such as
issueFunction in issueFieldMatch('project=ABC and type=DE', 'Summary', '(?i)fgh\\b')
This does the same as the above, just in a slightly different way and makes it much easier than duplicating both cases for each character. Which is a much better way for searching for specific words in a summary, and not just word fragments which can happen a lot for short regex strings.
I hope this helps. Let me know if you have any questions about this.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.