Is it possible to report on Comment Log through Advances reports?
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.