Skip to main content
A
adev1-Visitor
1-Visitor
January 7, 2016
Question

How to get Primary and secondry content from WTDocument

  • January 7, 2016
  • 3 replies
  • 2955 views

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

3 replies

C
Cliff_174667-Bedrock
7-Bedrock
January 8, 2016

ContentService should have APIs to achieve , did you check Javadoc?

A
adev1-VisitorAuthor
1-Visitor
January 11, 2016

Hello Feng,

Actually I am looking for database script to get the primary and secondary objects

M
MatthewKnight1-Visitor
1-Visitor
January 11, 2016

Can you paste your sql

A
adev1-VisitorAuthor
1-Visitor
January 11, 2016

Hello Matthew,

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 dm.wtdocumentnumber='0000000021'

and d.LATESTITERATIONINFO = 1;

Terms & ConditionsCookie settingsAccessibility statement