How can i report the folder path (within livelink) of a document ?

I am trying to get a list of documents that were created between a particular list of dates, and their path, that is under what folder path they were created. Any help is appreciated.

Find more posts tagged with

Comments

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

I'm thinking along the lines of "easiest to implement" to "hardest to implement":

How vital is it to see the path in the report? If you use the LiveReport report format, then you will have the Functions menu in the output, from which you can access the Info page. From the Info page you can see the "ancestry" of the items by clicking the "navigation" dropdown list at the upper left side of the page.

Do you need to see the full path, or is the parent enough? If the parent is enough, then you can write something like

select dtree.*, parent.name from dtree dtree, dtree parent
where dtree.parentid = parent.dataid

If you need to see the full path, I think the short answer is that you'll need to write a recursive query, joining DTree.ParentID to DTree.DataID of the parent. If you're using Oracle, I think you can use the CONNECT BY statement, but I don't know much about it. If you're using MSSQL, you'll probably need to write a stored procedure.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, July 26, 2002 3:56 AM
To: eLink Recipient
Subject: How can i report the folder path (within livelink) of a document ?

How can i report the folder path (within livelink) of a document ? Posted by hpglc on 07/26/2002 04:52 AM

I am trying to get a list of documents that were created between a particular list of dates, and their path, that is under what folder path they were created. Any help is appreciated.

eLink User

Message from Olson, Leonard <<A HREF="mailto:len.olson@rgsinc.com">len.olson@rgsinc.com> via eLink

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

You could also use the search feature instead of a LiveReport. A search can be defined by a date range, and the results page includes the location (parent object) of the item. The search results page won't show you the full path, but if you click on the location you will then go to the parent object -where you can click on the navigation menu in the upper left to see the full path.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, July 26, 2002 11:37
To: eLink Recipient
Subject: RE How can i report the folder path (within livelink) of a document ?

RE How can i report the folder path (within livelink) of a document ? Posted by eLink on 07/26/2002 11:36 AM
In reply to: How can i report the folder path (within livelink) of a document ? Posted by hpglc on 07/26/2002 04:52 AM

Message from Marie Lindsay <marie@opentext.com> via eLink

I'm thinking along the lines of "easiest to implement" to "hardest to implement": How vital is it to see the path in the report? If you use the LiveReport report format, then you will have the Functions menu in the output, from which you can access the Info page. From the Info page you can see the "ancestry" of the items by clicking the "navigation" dropdown list at the upper left side of the page. Do you need to see the full path, or is the parent enough? If the parent is enough, then you can write something like select dtree.*, parent.name from dtree dtree, dtree parent
where dtree.parentid = parent.dataid If you need to see the full path, I think the short answer is that you'll need to write a recursive query, joining DTree.ParentID to DTree.DataID of the parent. If you're using Oracle, I think you can use the CONNECT BY statement, but I don't know much about it. If you're using MSSQL, you'll probably need to write a stored procedure. -----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, July 26, 2002 3:56 AM
To: eLink Recipient
Subject: How can i report the folder path (within livelink) of a document ?

How can i report the folder path (within livelink) of a document ?

Posted by hpglc on 07/26/2002 04:52 AM

I am trying to get a list of documents that were created between a particular list of dates, and their path, that is under what folder path they were created. Any help is appreciated.

hpglc_(Delete)_1423369

Thank you for your responses. The methods you suggested do give a way of getting the path, but if you have like 1000 over documents and want a quick reference to their path (probably say for restoring), then its not a feasible solution. Hence I am trying to get a means to list the path.

Alex_Kowalenko_(akowalen_(Delete)_2285456)

The attached is an definition for an Oracle "LL_Path" function that will return the path of a Livelink object from its DataID. Note that a Livelink path includes all containers such as folders, projects, compound documents and root volume.The following example lists the path of every Livelink document:select DataID, LL_Path(DataID) from DTree where SubType=144-alex-

KX_Development_Support_Team_(merrilllynchglobaluse

To get the alias path of the document:Is there any method that returns me the alias path to the document or folder similar to the one we have "LL_Path".Please let me know.

ARES_MLCS

Here's another example of a function that will return the complete path for an object based on the object's dataid.Add the function to your select statement in the Livereport and identify a column alias for it.Hope it helps.