4 Replies Latest reply on Jul 26, 2013 9:27 AM by leslies

Visibility of a document (or any object)

leslies Jul 11, 2013 2:30 PM

I'm querying to find some documents and one of them keeps coming back but does not show in the Jive UI. I suspect it's hidden but I'm not sure where that information is stored. I have access to both the analytics and app databases but I'm not seeing it. Can anyone help?

Thanks!

Re: Visibility of a document (or any object)

josh.richau Jul 12, 2013 7:52 AM (in response to leslies)

Leslie,
It is possible that the doc was deleted but remains in the analytics history. Are you not able to find it by ID in the jivedocument table in the operational DB?
Like (0)

Actions
- Re: Visibility of a document (or any object)
  
  leslies Jul 12, 2013 9:37 AM (in response to josh.richau)
  
  Hi, Josh,
  
  Yes, it turns out the document was deleted and I do still see it in the jivedocument table. How do I know it's deleted? What I wasn't seeing was how to determine visibility, so I would still like to know that, too.
  
  Thanks!
  
  Like (0)
  
  Actions
  - Re: Visibility of a document (or any object)
    
    josh.richau Jul 12, 2013 9:45 AM (in response to leslies)
    
    Maybe the illustrious Aaron Johnson can help us out here - I am not sure where the delete information is captured.
    
    Like (0)
    
    Actions
Re: Visibility of a document (or any object)

leslies Jul 26, 2013 9:27 AM (in response to leslies)

The status of a document is in the jivedocversion table in the core database. The states I have seen so far and their respective status IDs are:
deleted - 11, archived - 8, published - 2.
Like (0)

Actions

Go to original post