My requirement is as below to have output in excel -
Please let me know how can this be achieved using DQL.
HI i want the answer for above one. pls help
Just use a tool like DQLTester or dqMan to execute the DQL and export to Excel.
@PedroMaia - have you ever tried using dqMan with repository that has records installed on it? We deployed records DAR and now dqMan no longer can connect to 7.3 repository. It worked perfectly before records installation. As part of records deployment, I vaguely remember seeing a warning that any 5.3 clients will no longer worked, but I figured dqMan was 6.x/7.x client since it uses dfc.jar.
Hi Johnny - I'm afraid I haven't worked with RM for some years, so I haven't tried this.I am using dqMan 188.8.131.52 that still relies on dmcl40.dll and dmcl.ini...
From custom Java program, you can use DFC to run the DQL and get the results. Then, use Java libraries such as Apache POI to generate an Excel.
dqMan has an option to export to Excel, but I am not quite sure it can connect to modern versions of Documentum 16.x
SivDM is possible to export DQL result to excel
@samagabrielb - does SivDM support Documentum 16.x? Most of the older DQL utilities are dmcl based and will not work on latest version of Documentum
if configured as DFC project along with latest jar, it is working fine