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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Alternatives to enrichment activity

guillermoL
Level 4
Level 4

Hi all,

After many hours wasted trying to figure out a complex enrichment activity, I've decided to give up and try to find alternatives to it. Actually it should be something very easy that can be solved with a bunch of SQL queries. But now I've got to a point that I need to make these SQL queries based on data on the target of the workflow. and it turns out that:

-     If I try to use a javascript code activity on the workflow, the target data does not seem to be available anywhere

-     If I try to use the delivery itself, there is no way I can run SQL there, neither with sqlSelect or with queryDef.

So, can anyone please recommend me what to do in case of something that can not be fullfilled with an enrichment activity?

Thanks a lot in advance

Guillermo

1 Accepted Solution
Adhiyan
Correct answer by
Employee
Employee

Hi Guillermo,

Have you explored the option of adding a control type of typology rule to the delivery to achieve the result.

there is a typology rule called :Analysis for the automatic integration of images in campaign which you can refer to which uses JS to create a queryDef condition to add images to a delivery.

Let me know if this solves the purpose.

Regards,

Adhiyan

View solution in original post

4 Replies
Adhiyan
Correct answer by
Employee
Employee

Hi Guillermo,

Have you explored the option of adding a control type of typology rule to the delivery to achieve the result.

there is a typology rule called :Analysis for the automatic integration of images in campaign which you can refer to which uses JS to create a queryDef condition to add images to a delivery.

Let me know if this solves the purpose.

Regards,

Adhiyan

View solution in original post

guillermoL
Level 4
Level 4

Thanks very much for the reply Adhiyan.

No, I had never heard about that. Could you possibly point me to some documentation?

Regards

Guillermo

Adhiyan
Employee
Employee

Hi Guillermo,

Here is the document on creating a control type typology rule :

Analysis and arbitration rules

Regards,
Adhiyan

guillermoL
Level 4
Level 4

Thanks Adhiyan,

I see, I can understand much better your point now. Unfortunately that particular Analysis for the automatic integration of images rule is not present on our instance, and all the ones we have, even some use SQL queries, do not 'send' any data to the delivery body itself. If you can share the script code of this particular rule probably can be easier.

Regards

Guillermo