Case insensitive search on Enhanced Search

Kev

Hey all,

I'm completely at a loss as to why my query is not returning any rows while trying to do a case insensitive search on the labels field.

The query that currently returns 514 rows is:
issueFunction in issueFieldMatch("type IN (Defect) AND status IN ("In Progress", "In Refinement", New, "To Do", Done)", labels, "^iBCore") ORDER BY Created ASC

But I know the query above is missing records which are labelled IBCORE instead of iBCore. So the plan is to do an insensitive search using:

 

issueFunction in issueFieldMatch("type IN (Defect) AND status IN ("In Progress", "In Refinement", New, "To Do", Done)", labels, "($i)iBCore") ORDER BY Created ASC

However this fails to parse.

Can anyone suggest a way to get this to work please? I'd really appreciate it.

Cheers
Kev

Tuncay Senturk _Snapbytes_

Hi,

The issueFieldMatch() function uses regular expressions, but afaik, it does not support case-insensitive matching directly within the regex pattern.

I am not sure but could you try this? adding ?i at the beginning of the regexp make the search case insensitive.    "(?i)^iBCore"