Hello I am using data base script to get the primary and secondary content of the WTDocument I am able to get primary but secondary I am getting issue does any one know how I can get the secondary object as well
I have come up with this which is giving me the result but I am not getting the Download url like we have in API ContentHelper.getDownloadURL, Can we download the file using the script ????
SELECT dm.name, ad.filename, ad.role
FROM wtdocument d, wtdocumentmaster dm, holdertocontent hc, applicationdata ad
WHERE hc.ida3a5 = d.ida2a2
AND d.ida3masterreference = dm.ida2a2
AND hc.ida3b5 = ad.ida2a2
and d.LATESTITERATIONINFO = 1;