1. Groovy Scripting Reference
  2. Using View Criteria to Query Case-Insensitively

Using View Criteria to Query Case-Insensitively

If you want to filter in a case-insensitive way, you can use the upper() function around the field name in the filter.

If you're not sure whether the operand value is uppercase, you can also use the upper() function around the operand like this:

  • upper(JustificationCode) = 'BRK'

  • upper(JustificationCode) = upper(:codeVar)

  • upper(JustificationCode) like upper(:codeVar)||'%'