2 Replies Latest reply on Sep 26, 2014 10:07 AM by pcrownov

    How are deleted files denoted in the database

    pcrownov

      Hey,

         I have been looking for a bit but can't find anything on this (or it's right in my face and I am just missing it...) I am trying to figure out how "deleted" discussions, blogs, docs, etc... are denoted as being "deleted" in the database. I know they aren't permanently gone as I can still see content that exists in spaces even after content deletion if I try and remove the space from the Admin Console. Does anyone know what field(s) denote this? or is there another table that contains all of the deleted content references? If anyone has info I'd love to hear it!


      Thanks

        • Re: How are deleted files denoted in the database
          Ryan Rutan

          Each content-type handles delete it’s own way.  Documents for example use the Version State.  Discussions I believe are either there or not in terms of deletion, but they do have different states for moderation that control their visibility.  Blog posts are similar to discussions, except they have the concept of existing prior to being visible as well.

           

          Does that help?

            • Re: How are deleted files denoted in the database
              pcrownov

              I found out why I was having a problem. The document and Space I was looking at is somehow bugged so a document thought it existed in the space but the space said it didn't have any docs in it. Instead the db was referencing a draft version of the Document as it's current version which was not making it very happy.

               

              For further reference, for documents, it is the "state" column in the jivedocversion table. You will also need the current version found in the jivedocument table to reference the correct information.