I've probably asked this before... but is there a way of using data linked to the profiles schema in ACS.
For simplicity lets say I have an Orders table linked to profiles table (1 cardinality simple link: so one occurrence of the order table can have at most one corresponding occurrence of the target table - but of course each profile record can have many order records)
Is there a way I can use the orders data in an email delivery to personalise?
My findings seem to be: * 1-n relationship data doesn't seem to be accessible in the personalisation menu in a delivery
* We are able to use workflow activities like add data/enrichment to add aggregated, deduped or even collection data to the temp schema, then this is accessible in the delivery.
The 3rd option is ok for simple use cases.
But I had an example where I have a data model like:
Profile --> Orders --> Order Items
To show all the orders and all the order items required 3 queries and 2 enrichments. Workflow collections are also limited to a defined number and store each record of the collection as it's own object. So when using this data in an email delivery, it gets rather cumbersome (not to mention risky by having to configure the max number of records COULD be needed).