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 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?
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.