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.

[stevenm]

Enhancement request entered.  

[Dave Smith1]

I can't seem to get either matches pattern or matches regex to work. I get a lot of SQL/MySql errors. 

Sadly, Regex matches in condition builder have been borked for some time:

Need syntax for "matches regex"

Matches Regex in Condition Builder

Re: What is the syntax for adding match regex in condition builder?

Re: RegEx in condition builder

Re: 'matches regex' in the condition builder not working

Re: Matches regex clarification

[nyancer3]

Unfortunately, this is a known error that is not going to be fixed: ServiceNow Customer Service System

Specifically, see the Workaround: "There is no workaround available. This query condition should not be used."

[Chuck Tomasi]

That makes me sad.

[xiaix]

It should make everyone sad.  To have an OOB qualifier option like this  and to have 0 documentation, 0 support, and then furthermore for SN to say this should not be used.  

Certainly a wtf moment.