Using SQL Expression

Avatar

Avatar

daehob42316144

Avatar

daehob42316144

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)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

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)

Avatar

Avatar

daehob42316144

Avatar

daehob42316144

daehob42316144

03-07-2018

Hi,

Wow!

Thank you so much for helping me.

Thanks,

Best Regards,

Daeho

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

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

Avatar

Avatar

daehob42316144

Avatar

daehob42316144

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