Using SQL Expression

Thank you for your response.

I want use 'REGEXP' in Oracle.

So I tried to use SQL Expression.

Could you please any advice about this topic?

Thanks

Best Regards,

Daeho

Hi,

Regex is not supported by ootb but i did some digging and you can use a regex like this if you are using PostgreSQL

// sample query using regEX ^\\d{8}

var queryCountPopulation = xtk.queryDef.create(

<queryDef schema="nms:recipient" operation="select">

<select>

<node expr="@mobilePhone" alias="@mobile"/>

</select>

<where>

<condition expr="@mobilePhone ~ '^\\d{8}'" boolOperator="AND"/>

</where>

</queryDef>);

var resCountPopulation = queryCountPopulation.ExecuteQuery();

logInfo(resCountPopulation);

alternatively,

<condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="@mobilePhone ~ '^\\d{8}'"

internalId="554827878"/>

Above can be used in workflow by editing the xml

Hi,

Wow!

Thank you so much for helping me.

Thanks,

Best Regards,

Daeho