ServiceNow Error when trying to use match regex, match pattern
Cannot for the life of me get these options to work in ServiceNow. No matter what string I try, I can't avoid this exception: Syntax Error or Access Rule Violation detected by database (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'MATCH_PAT '.b.*?' /* dev32225001, gs:1D04DB834F320300FFDBC4B18110C735, tx:ea11af' at line 1 Query is: SELECT count(*) AS recordcount FROM cmdb cmdb0 WHERE cmdb0.`sys_class_path` LIKE '/!!%' AND cmdb0.`name` MATCH_PAT '.b.*?' /* dev32225001, gs:1D04DB834F320300FFDBC4B18110C735, tx:ea11af8b4f320300ffdbc4b18110c7d4 */)
The other error indicates a usage of the function MATCH_RGX with the very same results. Can you please advise on how to use MATCH_RGX and MATCH_PAT?
Thank you, -Andy