Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Retrieving Content Type custom fields in OTBI

Summary:

Custom SQL for retrieving article and their associated custom Content Type schema for purposes of building a reference report with basic details of the article and key fields from the Content Type schema.

Content (please ensure you mask any confidential information):

Example - I tried using a data model in OTBI to pull data out of the table CSO_CONTENT and I could not find the field associated with 'Content Type'. I tried some others like CSO_CONTENT_TEXT as well. The hyperlinks go to the Oracle docs sites for the tables.

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!