1 Reply Latest reply on Feb 1, 2018 12:10 AM by lgtandi

    Filter in ForEachChild

    SusanJS Specialist

      Anyone know if it is possible to add a condition to the ForEachChild expression?  I want to use it to list out the messages of only unread journals in an email going out to notify the analyst that the customer has replied and include only the reply.  Otherwise the journal list can get quite long.

      If anyone has any other ideas on how to do this, I would love to hear it!

        • 1. Re: Filter in ForEachChild
          lgtandi Apprentice

          I'm not sure if I understand your question correctly, but yes, you can use an expression in the "childExpression" parameter. For example, the following expression will return the concatenation of the email address of all employees with status "Active" that are members of the current standard user team:

           

          ForEachChild("StandardUserTeam#",

              RecId,

              "Employee#.Rev2",

              "if Status == 'Active' then PrimaryEmail + ';' else ''",

              "LastName ASC"))

           

          Hope this helps,

          AnDi