nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

LiveReport similiar to Project Outline but also includes all document versions

abrown

I am having some trouble and I'm hoping you can help.I'm looking to run a report which is similiar to the 'Project Outline' but I would also like to have the report include all the versions of a document. I would like to select the project I am interested in and then have the report display all the object types and when it displays the 'documents', I would like it to include all the versions.Could you please let me know if this is possible?

Find more posts tagged with

Comments

eLink User

Message from Bhupinder Singh via eLinkJust some ideas that come to mind:It might be easier to use the Advanced Search to do this, because if theslice used on the search is "Enterprise (All Versions)" then you will getall versions of the documents in the results. You can setup an advancedsearch to return everything from a given location in Livelink including thefollowing term in your criteria, taken from the Livelink Query Language:("OTLocation": "project_workspace_ID")If, however, you still wish to pursue this using a LiveReport, I imaginethat you would need to create 2 reports:1. A main report that lists everything in the project workspace, and traceschildren of parent objects2. A subreport that returns all versions of versioned objects, taken fromDVERSDATA. Objects that are versioned would have a "details" link on themain report results, and clicking the "details" link would run thesubreport, which would query DVERSDATA and return all rows that correspondto the DataID of the row selected from the main report results.Sincerely,Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, March 03, 2003 1:30 PMTo: eLink RecipientSubject: LiveReport similiar to Project Outline but also includes alldocument versionsLiveReport similiar to Project Outline but also includes all documentversionsPosted by NorCDNAdmin on 03/03/2003 01:27 PMI am having some trouble and I'm hoping you can help.I'm looking to run a report which is similiar to the 'Project Outline' but Iwould also like to have the report include all the versions of a document.I would like to select the project I am interested in and then have thereport display all the object types and when it displays the 'documents', Iwould like it to include all the versions.Could you please let me know if this is possible?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

abrown

Do you exactly how the LiveReport would look for capturing all the document versions under a certain container? I am having some trouble getting the results I want.I tried the advanced search but we were having some trouble with our index last week so I don't think it is capturing all the versions.Thanks in advance for your help.

eLink User

Message from Ivan Stefanini <<A HREF="mailto:Ivan.Stefanini@fantastic.com">Ivan.Stefanini@fantastic.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

unsubscribe

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, March 05, 2003 3:33 PM
To: eLink Recipient
Subject: document versions under a certain container

document versions under a certain container Posted by NorCDNAdmin (Brown, Allen) on 03/05/2003 09:29 AM
In reply to: RE LiveReport similiar to Project Outline but also includes all document versions Posted by eLink on 03/03/2003 04:43 PM

Do you exactly how the LiveReport would look for capturing all the document versions under a certain container? I am having some trouble getting the results I want.
I tried the advanced search but we were having some trouble with our index last week so I don't think it is capturing all the versions.

Thanks in advance for your help.

eLink User

Message from Bhupinder Singh via eLinkSuppose a folder has a DataID of 2945. The following SQL statement willreturn all versions of all versioned objects in that folder:select * from DVERSDATA V where V.DocID in (select DataID from DTREE T whereT.parentID=2945)To return all versions of just documents (since Workflows are also versionedobjects and the above query will return all versions of all workflows):select * from DVERSDATA V where V.DocID in (select DataID from DTREE T whereT.parentID=2945 and T.SubType=144)...since 144 is the subtype for documents.Sincerely,Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, March 05, 2003 9:33 AMTo: eLink RecipientSubject: document versions under a certain containerdocument versions under a certain containerPosted by NorCDNAdmin on 03/05/2003 09:29 AMDo you exactly how the LiveReport would look for capturing all the documentversions under a certain container? I am having some trouble getting theresults I want.I tried the advanced search but we were having some trouble with our indexlast week so I don't think it is capturing all the versions.Thanks in advance for your help.[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: LiveReport similiar to Project Outline but also includes alldocument versionshttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2980813&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe