Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Using SQL Expression

daehob42316144
Level 2
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
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

0 Replies
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

daehob42316144
Level 2
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

Amit_Kumar
Community Advisor
Community Advisor

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
Level 2
Level 2

Hi,

Wow!

Thank you so much for helping me.

Thanks,

Best Regards,

Daeho