BIP Report - SQL script to get UCM file details foe the given Content id

 

select DDOCNAME, DDOCAUTHOR

from

revisions 

where 1=1

AND DDOCTITLE like 'PDH_ITEM_CAT_MM%'

AND (DDOCNAME IN (:p_DOCID) OR COALESCE(:p_DOCID, NULL)IS NULL)

AND DCREATEDATE >=To_date(:p_date, 'MM-dd-yyyy HH24:MI:SS')

output 

<?xml version="1.0" encoding="UTF-8"?>

<!--Generated by Oracle Analytics Publisher -Data engine, datamodel:_Custom_Cisco_Custom_SCM_Integrations_Cs_GetItem_Report_CS_UCMREPORT_DM_xdm -->

-<DATA_DS>

<P_DATE>09-30-2022</P_DATE>

<P_DOCID/>

-<G_1>

<DDOCNAME>UCMFA01690040</DDOCNAME>

<DDOCAUTHOR>name@gmail.com</DDOCAUTHOR>

</G_1>

-<G_1>

<DDOCNAME>UCMFA01689832</DDOCNAME>

<DDOCAUTHOR>name@gmail.com</DDOCAUTHOR>

</G_1>

</DATA_DS>