In my request process, there are two approval stages: a primary and a secondary. Each has it's own FRS_Approval record which in turn stores the FRS_ApprovalVoteTracking that contains the owner (approver) information that I need. I want to put this information (all of the owners) into an email that is being sent out through ServiceReq. If it was the child, I would use ForEachChild, but how do I pull this info from the grandchild on the fly?
Just embed a second ForEachChild statement within the called expression of the first. The first calls each approval and the second calls the approvers in the list.
Thanks AlasdairRobertson. It wasn't terribly clear on where to embed the second statement, but I figured it out for anyone else needing this in the future:
$(ForEachChild("ServiceReq#", RecId, "FRS_Approval#.", "ForEachChild('FRS_Approval#', RecId, 'FRS_ApprovalVoteTracking#.', 'OwnerFullName') + '\r\n'", "CreatedDateTime ASC"))
hehe the fun is in figuring it out. Its a really powerful technique that I use in lots of situations with both ForEachChild and ChildFold.