Get Folder list of custom categories

pds1

Hello,

How Can I get the Folder list of custom categories  in OpenText using T-Sql?

pds1

I am looking following information from OpenText Table Schema in Sql Server:

OpenText Full Path and associated Properties like below:

OpenText Full Path

Company/Corporate/Sales/_Sales Contract

Property

Contract Type 

Path

Date Signed

Customer Sold To Number

Customer Name     

City

State