morning, all. i need to filter out child records in my body template that have a non-blank entry in “Finished Date”. how do i express filtering for child records in a template?
i presently have:
|<<Start: ORDERBY(SELECT([Related STAFF LISTs],TRUE),[SURNAME])>><<[Name]>>||<<[Surname]>>||<<[Job Title]>>||<>||<><>|
i want to filter out child fields “Finish Date”<>"
thank you for your help