This content has been marked as final. Show 1 reply
Check out the jivecommunity table. The query below pulls in all comments on documents specifically but you could expand to other content types.
select com.commentid, doc.documentid, community.name, com.userid, person.username, to_timestamp(com.creationdate/1000) as "creationdate" from jivecomment com left join jiveobjecttype objtype on objtype.typeid = com.objecttype left join jiveuser person on person.userid = com.userid left join jivedocument doc on doc.internaldocid = com.objectid left join jivecommunity community on community.communityid = doc.containerid where com.objecttype = '102' order by commentid asc