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"
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.