topic Re: Regex in filter with variable in Active IQ Unified Manager Discussions

Regex in filter with variable

dblackwe — Wed, 04 Jun 2025 15:13:07 GMT

How do we use regex in a filter?

When I do..

where column regex '${variable}$'

I want where column ends with variable, but $ and {} are both regex code bits and I can't get the sql query I need. Any help would be greatly appreciated.

Re: Regex in filter with variable

sinhaa — Wed, 12 Apr 2017 11:19:57 GMT

@dblackwe

Where columns REGEXP '${Exp}'

So now Exp becomes a parameter for the Filter. While testing it, provide any expression as you want. If you need 'ends with 01' provide the value of Exp : 01$

Ends in a-z : [a-z]$

sinhaa

Re: Regex in filter with variable

sinhaa — Wed, 12 Apr 2017 17:54:26 GMT

@dblackwe

I can suggest another way. If you are finding it difficult to get your filter SQL with REGEXP then just don't have a regexp in filter SQL at all. Have it as a plain parameter like

WHERE column LIKE '%${varible}'

So now your filter has a parameter, $variable

In workflow User-Input, you can define your Regex for this string $varibale. So this will give you the desired result.

sinhaa