How to find a links/contents by given a top level site from content table in Ektron database?

Vote:
 

I need to produce a custom google sitemap by gievn language (1033) and top site name (www.mycompany.com), I can find the content record for the top site for that language, can someone shed some light on how can i find all pages recursively under this top site using SQL query?

Thank you so much!

John

#176400
Mar 17, 2017 17:50
This thread is locked and should be used for reference only.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.