Try Calling the smartobject inside the email body.

Hi Sharp,

If it is one column, As said by Vijay, you can call smartobject in email body and select the option(Return all results that match filter).

So that it will result all the values.

And if you want to display more than one column, then you need to write some custom code.

Regards

SK

Hi all,

Thanks for the replies.

There are several columns in the records, so does anyone happen to have a step by step guide on how to achieve this with K2 Studio + Email Action?

Thanks

Dear Sharp,

i recorded all the steps, please find the attachement.

Note: you need to use k2 for visualstudio, beacause you cant write the custom code in k2 studio.

Regards

SK

Using K2 5
I have an email that I'm needing to display a list of records populated from a SQL View.

I have 1 column that needs to display some concatenated information but I would like it to display as a list, not as a paragraph with all the results grouped together.

Is there a way to parse the records out to display as rows?
Example:

Current:   
Record 1   Record 2   Record 3  Record 4...................

Would like:

Record 1

Record 2

Record 3

Record 4

One solution that i can suggest is to try using Join function and call the smartobject Column in Values and in Separator add this  <br/>.

This will render all the values as html, each seperated by <br/> tag and in email it will be rendered as you required.

Regards,

Vijay.

I was just about to come in and post the solution I found out which is exactly what you stated below.

Found a post that had information about the join but using a  ',' or ';'  so I just thought I'd try the </br> which worked perfectly!

Thank you!