3 Replies Latest reply on Jul 24, 2013 12:28 PM by konatham

    Jive Database 6

    konatham

      Hello,

      Currently we are running on Jive 5 and migrating to Jive 6, while working with databases for Jive 5&6. I noticed a difference in the tables.

      Actually one table what we are working on is not appeared in Jive 6(i.e., jivecommunitytag) this table is related to jivetag table in Jive 5.

      How can we connect/join jivetag and jiveuser table based on tagid or userid.

      I want to know weather this table is deleted or the features are added to other tables? Can you clarify my doubt and specify the other tables which these features are included(if there)?

       

      Waiting for response, Any kind of help is appreciated.

       

      Thanks,

      Shilpa

        • Re: Jive Database 6
          mtuljapurkar

          Shilpa,

           

          You can take a look at the jiveObjectTag table. This table generalizes the association between tags and other entities.

           

          -Mandar

            • Re: Jive Database 6
              konatham

              Thanks for your response Mandar,

              we need results of both userid and tagid(i.e., tags created by particular user), but jiveobjecttag table does not have any information about the user or userid.

              The previous table in Jive 5 jivecommunitytag table has both user & tag information, we are looking for similar tables to get tagid & userid.

               

              --Shilpa

                • Re: Jive Database 6
                  konatham

                  Hi Mandar,

                   

                  Now I can able to fetch results of both user & tags.

                  I used jivetag, jiveobjecttag, and jivebooknmark tables where id (jivebookmark) is same as objectid (jiveobjecttag).

                   

                  The working Query is:

                  SELECT

                    jiveobjecttag.objectid,

                    jivetag.tagid,

                    jivetag.tagname,

                    jiveobjecttag.objecttype,

                    jivebookmark.creatorid,

                    jiveobjecttag.creationdate,

                    jivebookmark.makedid

                  FROM

                     jivetag left outer join

                        (jiveobjecttag left outer join jivebookmark

                        on (jivebookmark.id = jiveobjecttag.objectid))

                     on (jiveobjecttag.tagid = jivetag.tagid)

                  WHERE

                    jiveobjecttag.objecttype = *** and

                    jivebookmark.creatorid = ***

                  order by

                  jiveobjecttag.creationdate;

                   

                   

                  Thanks,

                  Shilpa.