HI,
I have a quick question. Is there a way to query the vignette DB to get all the information of particular CIs of certain type along with its channel association?
For instance,
EXAMPLE_CTD: ID, TITLE, DESCRIPTION, IMAGE
I would like to query the DB to get a list of all the CIs (of type EXAMPLE_CTD), plus their associated channels and sub-channels. Ex:
ID, TITLE, DESCRIPTION, IMAGE, CHANNELS
a82e2115a4d20310VgnVCM10000066ca7898____, Title1, Desc1, img.jpg, /ParentCh/subch1/subch2
…
…
Please note that we need to accomplish this by querying the DB directly instead of using any APIs. Any help would be greatly appreciated.
-BJ
