RSSCE Oracle SQL
May 23
Ideally you should use CE Enterprise Manager to run any query.
This is some of the query if you really want to run the query behind the scene. Custom property column names are generated unique for each environment.
– doc version size in millions
select count(*)/1000/1000 from schema.DOCVERSION;
– Find out number of documents in Object Store
select count(*) from schema.DOCVERSION, schema.CLASSDEFINITION where schema.DOCVERSION.OBJECT_CLASS_ID = schema.CLASSDEFINITION.OBJECT_ID and symbolic_Name in (‘DocClassSymName’, ‘DocClassSymName’);
List down document class tree (as seen in EM)
select lpad(‘__’,5*(level-1)) || symbolic_name from schema.classdefinition start with symbolic_name = ‘Document’
connect by prior object_id = superclass_id;
Document created by user ‘user1′ max 10
select schema.DOCVERSION.OBJECT_ID, schema.DOCVERSION.XXX_DOCUMENTTITLE from schema.DOCVERSION where rownum < 10 and schema.DOCVERSION.CREATOR = ‘user1′;
Folder query inside Parent folder
select * from schema.container where schema.container.name = ‘XXX’ and parent_container_id = (select object_id
from schema.container where schema.container.name = ‘ParentFolder’);
RCR Query
select schema.RR.head_id “GUID”, cn.XXX_customprop “SymbolicName”
from schema.relationship RR ,schema.container CN, schema.classdefinition CD
where cd.object_id = cn.object_class_id
and cd.symbolic_name = ‘FolderSymName’
and rr.tail_id = cn.object_id;