Using my SQL scripts in data schema expression

[Heku_]

Hello, I would like to use this function:

In the data schema declaration like this:

<attribute expr="GetEmailPreDomain('prefix@xxx.xxx')" label="x" name="x"
type="string"/>

So its value is "prefix"

How can I do this?

Thank you in advance.

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni 

[ParthaSarathy]

Hi @Heku_ ,

Try this expression,

expr="Substring(@email,0 ,Length(@email)-Length(GetEmailDomain(@email)))"

<attribute expr="Substring(@email,0 ,Length(@email)-Length(GetEmailDomain(@email)))" label="Email Prefix" name="emailPrefix" type="string"/>

Disconnect & Reconnect.

[Heku_]

Thank you, but i need to do more complex things, like doing a SELECT x FROM actual table order by x DESC LIMIT 1

[Amine_Abedour · Accepted solution]

Hello @Heku_,

Please referre to this documentation to do what you want to do : 

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/api/addi...

Br,

Amine