on top of the Audit log screen, you can see the SQL query.
SELECT al.*,r.title, IF(r.id,1,0) as isrecord,u.username FROM jos_js_res_audit_log al LEFT JOIN jos_js_res_record AS r ON r.id = al.record_id LEFT JOIN jos_users AS u ON u.id = al.user_id WHERE al.type_id IN (1,2,3,0) AND al.section_id IN (1,2,3,0) ORDER BY al.ctime desc
Problem
Announcement
Conversation
Idea
Praise
Question
Open
on top of the Audit log screen, you can see the SQL query.
SELECT al.*,r.title, IF(r.id,1,0) as isrecord,u.username FROM jos_js_res_audit_log al LEFT JOIN jos_js_res_record AS r ON r.id = al.record_id LEFT JOIN jos_users AS u ON u.id = al.user_id WHERE al.type_id IN (1,2,3,0) AND al.section_id IN (1,2,3,0) ORDER BY al.ctime desc