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
<<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
<<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`)>>```
