• New Feature
  • Status: Open
  • 2 Major
  • Resolution:
  • ehcache
  • mdevgan
  • Reporter: lgilbert
  • June 14, 2013
  • 0
  • Watchers: 7
  • August 27, 2013

Description

Comments

Lee Gilbert 2013-06-14

It should be possible to search for word match in a string, and or use regex without crippling allowable regex operators. Currently the only way to wordmatch is using ilike(“* myword *”) and this requires all strings to start with space in position 1. It would be nice if full regex was supported even though it can be a full index scan.

Fiona OShea 2013-06-17

to be prioritised and scheduled

Vitaliy Funshteyn 2013-06-24

The example given by the reporter is not actually accurate. {{ilike(“* myword *”)}} does not require the string to start with a space. It only requires that there is a substring {{” myword “}} anywhere in the string.

I personally think this is a case of a user misreading the docs. We do not support regex expressions, but using substring search with wildcards is supported. Although using leading wildcards is not recommended for performance reasons, but that is a separate issue.