I have a smart object with a list method that returns two fields (id, number) from a database table. I would like to email all the results of the list method. I have created a workflow with a smart object event that calls the list method. When I try to map the results from the smart object method (ID, Number) I can only do it to two data fields (ID, Number). When I add email event and use the two data fields in the body of the message I only get the last row of the database table instead of all the rows.
I have tested the smart object using the smart object tester and the list method returns all the rows of the table.
Any ideas?
thanks,
Luis