AnsweredAssumed Answered

JiveBrowse and JiveDocument Table Questions

Question asked by Alex Evans Employee on Aug 31, 2018
Latest reply on Sep 5, 2018 by gcarrion03

Q1: Write a query to show documents with more than 2 versions.
Q2: Write a query to show documents that aren't in the browse index.

 

jivebrowsecnt
https://docs.jivesoftware.com/schemas/9_0/sbs/tables/jivebrowsecnt.html

Column | Type | Modifiers
------------------+------------------------+-----------
browseid | bigint | not null
objecttype | integer | not null
objectid | bigint | not null
authorid | bigint | not null
status | integer | not null
containertype | integer | not null
containerid | bigint | not null
creationdate | bigint | not null
modificationdate | bigint | not null
lastactivitydate | bigint | not null
subject | character varying(255)

 

 

jivedocument
https://docs.jivesoftware.com/schemas/9_0/sbs/tables/jivedocument.html
Column | Type | Modifiers
-----------------+------------------------+-----------
internaldocid | bigint | not null
userid | bigint | not null
documentid | character varying(255) | not null
containertype | integer | not null
containerid | bigint | not null
typeid | bigint | not null
editpolicy | integer | not null
creationdate | bigint | not null
expirationdate | bigint | not null
recommended | smallint | not null
meanrating | integer | not null
readcount | integer | not null
commentstatus | integer | not null
workflowid | bigint |
versionid | integer | not null
exstoragefileid | bigint |

Outcomes