Livelink docs in a similar folder structure

Is there any way to create a list of documents that can be opened from the report that are within certain similar folder structure.My structure is property management\concept\state\number\legalwhere state is each state that we have a unit in and number is the the unit number.My database is MSSQL and my LL version is 9104.thanks,Joy

Find more posts tagged with

Comments

Chad Latka

Message from Latka, Chad J. \(IT\) via eLinkIf I understand this correctly, are you asking if you can view forexample all the documents that may be ina certain folder such state, and then be able to open them? You couldtry writing an LiveReport that has asub-report. The input could be the DocId In order to do that, you musthave the following for a LiveReport to work correctly: Dtree.SubType, Dtree.DataID, Dtree.Name, DVersData.Version,DVersData.FileName, DVersData.MimeTypeHope this helps! Good luck. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, December 09, 2005 3:02 PMTo: eLink RecipientSubject: Livelink docs in a similar folder structureLivelink docs in a similar folder structure Posted by Svendsen, Kris on12/09/2005 03:57 PMIs there any way to create a list of documents that can be opened fromthe report that are within certain similar folder structure.My structure is property management\concept\state\number\legalwhere state is each state that we have a unit in and number is the theunit number.My database is MSSQL and my LL version is 9104.thanks,Joy[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Luke_Morris_(brinkadmin_-_(deleted))

Thanks for your comments. I'm actually looking for something that will give the list of all documents that are in the legal/documents structure within all the state folders and all the number folders.For instance, in Alabama say I have 1 store and in California say I have 2 stores (etc), I want a list of all the documents within ...Alabama\102\legal\documents+ all the documents that are in...\California\101\legal\documents+ all the documents that are in...\California\102\legal\documentsand be able to click on the icon and view the document.Of course, there are more states and many more stores, but just for the sake of explanation I have abbreviated the numbers. I hope that is a little bit clearer explanation.Thanks,Joy

Alex_Kowalenko_(aka_-_(deleted))

Message from Alex Kowalenko via eLinkThe following SQL query will find all direct descendent documents in atwo-level "legal:documents" folder structure anywhere in Livelink:select %1 from DTree where %2 and ParentID in ( select DataID from DTree where Name = 'documents' and %3 and ParentID in ( select DataID from DTree where Name = 'legal' and %3 ) )LiveReport parameters:Param %1: Report FieldsParam %2: Filter DocumentParam %3: Filter FolderTo find all documents under a folder you would have to use a hierarchyconstruct in your SQL query. For Oracle this is the 'connect by' clause. ForMSSQL this is a custom stored procedure.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, December 13, 2005 3:04 AMTo: eLink RecipientSubject: livelink docs in a similar folder structurelivelink docs in a similar folder structurePosted by Svendsen, Kris on 12/12/2005 11:00 AMThanks for your comments. I'm actually looking for something that will givethe list of all documents that are in the legal/documents structure withinall the state folders and all the number folders.For instance, in Alabama say I have 1 store and in California say I have 2stores (etc), I want a list of all the documents within ...Alabama\102\legal\documents+ all the documents that are in...\California\101\legal\documents+ all the documents that are in...\California\102\legal\documentsand be able to click on the icon and view the document.Of course, there are more states and many more stores, but just for the sakeof explanation I have abbreviated the numbers. I hope that is a little bitclearer explanation.Thanks,Joy[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Livelink docs in a similar folder structurehttps://knowledge.opentext.com/knowledge/livelink.exe/open/4394210Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.