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):
0