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

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