matches regex or matches pattern

[stevenm]

So I have a requirement to filter SN on the 5th and 6th positions of a server name. This is in Helsinki and on a reference field within a Record Producer.   I can't seem to get either matches pattern or matches regex to work.   I get a lot of SQL/MySql errors.   What's the trick?   I'll keep googling.   Thanks.

[Dave Smith1 · Accepted solution]

The biggest WTF is that a feature - known broken and recommended not to be used - still hasn't been pulled.

If it doesn't work and serves no purpose... why leave it in?

[Jody Roberts]

What's the trouble?  Is it unfixable?  Would it require replacing MariaDB or something?  I don't get why it's so borked and has gone this long.  It's a regex, they've been around since the dawn of unix.  It's been 5y and still hanging around. ServiceNow, please please fix