I'll be lazy and give you some LIST_TABLE code that works. You'll have to sort through it to see if it can help. This is the HTML from an HTML document embedded in an email notification. Hope it helps.
Hello <<Investigator.FirstName>>,
You currently have <<Count PHS WHERE (PHS.Investigator=Investigator and PHS.Case_Stage<> '7 - Closed' AND PHS.Candidate.Status='Active')>> open investigations:
<<LIST_TABLE(FIND PHS WHERE (PHS.Investigator=Investigator AND PHS.Case_Stage<> '7 - Closed' AND PHS.Candidate.Status='Active') ORDER By Case_DateOpened DESC,CandidateFullName,CandidateGroup,Case_DateOpened,Case_Stage,Case_ModifiedTimeStamp)>>
You currently have <<Count Review WHERE(Review.Reviewer=Investigator AND (Review.Complete<>'Yes' OR Review.Complete IS UNDEFINED) AND Review.Results IS UNDEFINED) >> pending review assignments:
<<LIST_TABLE(FIND Review WHERE Review.Reviewer=Investigator AND (Review.Complete<>'Yes' OR Review.Complete IS UNDEFINED) AND Review.Results IS UNDEFINED Order by Review.DateStarted,CandidateName,CandidateGroup,DateStarted,StartedBy,ReviewPurpose,NotesToReviewer)>>
You currently have <<Count Task WHERE(Task.Investigator=Investigator AND Task.Status<>'Completed' AND Task.Status<>'Abandoned' AND Task.Status<>'Rejected' AND Task.DateInitiated IS DEFINED) >> pending tasks:
<<LIST_TABLE(FIND Task WHERE(Task.Investigator=Investigator AND Task.Status<>'Completed' AND Task.Status<>'Abandoned' AND Task.Status<>'Rejected' AND Task.DateInitiated IS DEFINED) Order by Task.DateDue DESC,SC_CandidateFullName,TaskName,Status,InitiatedBy,DateDue,TaskDetails)>>
