Channel Report

Chandrapal_Reddy

Hello

 

    Can you help us in generating a report information which consists of all child channel under a parent channel with all pages (article pages) and assets (images & pdf) associated to those channels ?

 

   I actually need a SQL query  to get the report from SQL Server 2005 database.

 

    I wrote a query which actually fetches the child channels under a parent channel but could not form the query which includes article pages & assets (images & pdf) associated to the channel.  Attached the report and the query in the excel sheet

 

   Need your Help/Advise on this !!

 

Thanks

Chandrapal Reddy

Channel Report.xlsx

eLink User

Shouldn't you use the API to generate this report?

Sohail

On Fri, Sep 27, 2013 at 9:05 AM, eLink Entry: Discussion Group - Web Experience Management <v7webcontentmanagement@elinkkc.opentext.com> wrote:

Channel Report

Posted bychreddy@deloitte.com (Reddy, Chandrapal)On 09-27-2013 09:03

Hello     Can you help us in generating a report information which consists of all child channel under a parent channel with all pages (article pages) and assets (images & pdf) associated to those channels ?    I actually need a SQL query  to get the report from SQL Server 2005 database.     I wrote a query which actually fetches the child channels under a parent channel but could not form the query which includes article pages & assets (images & pdf) associated to the channel.  Attached the report and the query in the excel sheet    Need your Help/Advise on this !! ThanksChandrapal Reddy

Attachment Links:

Channel Report.xlsx(12 KB)

---

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center

--
Regards,
Sohail Aboobaker.
Accumulate Consulting Inc.
www.letsaccumulate.com.
Ph: 416 907 9050