Alternatives to enrichment activity

[guillermoL]

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

[Adhiyan · Accepted solution]

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

[guillermoL]

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]

Hi Guillermo,

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

Analysis and arbitration rules

Regards,
Adhiyan

[guillermoL]

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