Reporting on Comment Log

Hi Ada Napierala,

Yes, using advanced reports you can report on content in comment log entries. A sample query to find all comment log entries on a specific record would look like:

SELECT cl.entry, cl.date_entered FROM commentlog cl LEFT JOIN commentlog_rel clr ON cl.id = clr.commentlog_id LEFT JOIN <source module table> smt ON clr.record_id = smt.id WHERE clr.record_id = <source module record GUID> AND clr.module = <source module> AND cl.deleted = 0;

One thing to note is that contextual references in comment log entries like @ user mentions and # record links will be encoded in the results you get directly from the database. 

Chris

Chris Raffle thanks for that :)