1 Reply Latest reply on Jan 9, 2014 2:51 PM by mnevill

    how can I view docs with tags associated with them?

    erkjones Intermediate

      I have a list of docs created in Jive using the query below, but I would like to add the tags associated with the docs, since that is where the doc author is mentioned.


      SELECT    jd.creation_ts, jc.name, jd.title, jd.document_id

      FROM        jivedw_document_sf AS jd INNER JOIN

      jivedw_container_sf AS jc ON jd.container_id = jc.container_id

      WHERE    (jd.container_type = 14) AND (jc.container_type = 14)

      ORDER BY jc.name, jd.creation_ts DESC


      How can I associate tags with docs?