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