Event Action Load Collection

jennifer-foster

I have an event handler that is trying to get all of the *notes* associated with a Row Pointer.  There could be multiple notes and I want to get all of them.  This is the Load Collection:

IDO("SLObjectNotes")
PROPERTIES("SpcnNoteDesc, SpcnNoteContent, RefRowPointer")
DISTINCT(FALSE)
FILTER(SUBSTITUTE("RefRowPointer= '{0}'", V(vSRORow)))
SET(R(Notes) = RESULT)

What I cannot seem to figure out is how to then get each of the notes and put them all into a string so that I can add them to the body of an email that gets sent.  Does anyone have some suggestions about how to do this?

Carsten Steinhoefel

You will have to build your own loop with a row counter variable, Set Values and Branch actions.

You can get the number of rows in your result set with
ROWS(Notes)

If your row cournter is called e.g. vCurrentRow, you get the values for that row like
P(Notes, V(vCurrentRow), "SpcnNoteDesc")

One standard Event Handler is the "Alert on Item Price Response Creation" (in the latest SL version in Cloud) - there are probably easier examples though as it does a lot of things inside the loop.