Using SQL Expression

daehob42316144

28-06-2018

Hello.

I'm Daeho.

Please let me know about SQL expression in filtering condition.

I don't know how to define filter by using SQL Expression.

If you have any experience about that or best practice, please let me know that.

Thanks,

Regards

Daeho

1518041_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Amit_Kumar

MVP

29-06-2018

Hi Daeho,

This option was available in old neolane versions. Adobe introduced a new security patch in 6.1 which will not allow this. This can be enabled by updating allowSQLInjection  in server configurations.

1518244_pastedImage_0.png

Read this for more details: General configurations

Regards,

Amit

Answers (3)

Answers (3)

Amit_Kumar

MVP

03-07-2018

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

daehob42316144

01-07-2018

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