this returns but giving us all changes. I really j...
# suiteanalytics
a
this returns but giving us all changes. I really just want material ones:  CASE WHEN ((to_char({lastmodifieddate},'MM/DD/YYYY HH:MI AM'))>(to_char({systemnotes.date},'MM/DD/YYYY HH:MI AM'))) AND {systemnotes.type}='Change' THEN 1 ELSE 0 END