Hi @reddyx0133 - instead of the comma-separated string, we were able to find an approach that iterated through all of the records belonging to a user in a data table & create a list of their specific associates that were active on the website in the past 24 hours &send in an email to the user. See:h...

We were able to implement this solution & it worked great. We have other use cases where this would be really helpful as well, just weren't familiar that you could loop through values using that dot notation approach. Thanks a lot!

We were able to resolve the issue by updating the link element on our custom schema to have a revLink attribute (we used the Broadlog schema as a reference and made sure our link was structured similarly since that table was working).

Hi @Sukrity_Wadhwa, Thank you for checking. I am able to get David's code below to work fine. However, when I use the custom table which "recipient" links to, I keep getting an error. I've tried using different variations of the table name (it actually gets generated as recipient.Consumers_contact.f...

--

Thanks David. Just to confirm, you're able to just use this kind of dot notation for any tables linked to the recipient table without needing a query? We will give it a shot today to see if it will be possible with our scenario where we have a foreign key on the recipient record which links to a for...

Hello, We have table which links to the recipients table with a 1 to many relationship (1 recipient may have many records in the 2nd table). We are trying to list data from all linked records in the 2nd table for each recipient. For example, in an email to John Doe we would like a bulleted list of I...

I ended up doing the same. Tried using the memo field, but later found out since that is an XML type & not a SQL field it can't be used in deliveries. So, I ended up using a string with length="1000" to allow the advisor HTML data to fit. Seems to be working now, thanks again!

Were you able to find a solution for displaying the contents of the memo/text field in the email? I can see the values in the schema but in the delivery <%= targetData.advisors %> is just rendering blank.

Thanks Darren. That's a great suggestion. I will give this a shot today & see if I can get those arrays added to the temp schema in the form of text fields.