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
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.