Expand my Community achievements bar.

SOLVED

Using SQL Expression

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

4 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 2

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

Avatar

Level 10

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

Level 2

Hi,

Wow!

Thank you so much for helping me.

Thanks,

Best Regards,

Daeho