LiveReport Help Required

Hi everyone,

i need to create a livereport in which i want to fetch all the users and information related to them like where they are owner, creator, document reserve by them and workflows item pending with them.

can anyone help on this or share the database design of the content server.

Regards

Find more posts tagged with

Comments

Kyle_Swidrovich

Hello Ghulam,

You must sign an NDA with OpenText in order to obtain the schema document for Content Server.

Please contact your local support office to accomplish this.

Regards,
Kyle

Colin_Schmidt

Or, if you have SQL Developer or TOAD, you can see the Tables and Columns there. The Schema reference is a help, though.

Attached is SQL code for Oracle that works for an object if it's not within a Project or any other different type of location under Enterprise WS. The Oracle SYS_CONNECT_BY_PATH will not work down within a Project. The Subtypes list is much larger and can be found in the KC without an NDA, I believe. It is also incomplete, as modules bring in their own list and so the list is nominal. The rest you figure out on your own.

Object-Info-and-Path.txt