How To Write A SQL Query That Identifies A Project And The Assets Associated To the Project

(Doc ID 2026783.1)

Last updated on NOVEMBER 16, 2015

Applies to:

Oracle Commerce Platform - Version 9.0 and later
Information in this document applies to any platform.

Goal

Looking to identify the list of assets as displayed in the Content Administration project's asset tab. Would like the query to display the Project, Asset, Type and Modified\Create Date.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms