How to display the path of a specific Livelink ID

Hi,

I have list of document ids. My requirement is to display the path of those IDs.

Can someone help me on this please?

I used below query. It doesn't help me.

select dataid, name, sys_connect_by_path(name,':') path from dtree where subtype = 144 connect by prior dataid = parentid and dataid in (3987729) start with parentid = -1;

Our database is Oracle 10g

Livelink version 9.7.0

Regards,

Find more posts tagged with

Comments

Colin_Schmidt

You could put in the following code as a “function” and call it for each object. This was constructed by someone here a year or so earlier.

create or replace

FUNCTION Get_Descriptive_Document_Path

(i_dataid IN DTREE.dataid%TYPE) RETURN VARCHAR2

v_path VARCHAR2(2000);

CURSOR c_hierarchy(cp_dataid IN DTREE.dataid%TYPE)

SELECT DECODE(subtype,3030202,'[Community]',142,'[Personal Workspace]',202,'[Project Workspace]',128,'[Workflow]',161,'[Workflow]',NULL) || NAME AS "NAME"

FROM DTREE

WHERE DATAID <> cp_dataid

CONNECT BY PRIOR ABS(parentid) = dataid

START WITH dataid = cp_dataid

ORDER BY LEVEL DESC;

BEGIN

FOR rec IN c_hierarchy(i_dataid) LOOP

v_path := v_path || rec.NAME|| ':';

END LOOP;

RETURN v_path;

END;

Colin J. Schmidt

MSLive/Livelink Admin

Tulsa, OK 74172

Colin.Schmidt@williams.com

If you have received this message in error, please reply to advise the sender of the error and then immediately delete this message.

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, May 07, 2013 4:34 AM
To: eLink Recipient
Subject: How to display the path of a specific Livelink ID

How to display the path of a specific Livelink ID

Posted by livelinkadmin@pdo.co.om (Admin, Livelink) On 05-07-2013 05:30

Hi,

I have list of document ids. My requirement is to display the path of those IDs.

Can someone help me on this please?

I used below query. It doesn't help me.

select dataid, name, sys_connect_by_path(name,':') path from dtree where subtype = 144 connect by prior dataid = parentid and dataid in (3987729) start with parentid = -1;

Our database is Oracle 10g

Livelink version 9.7.0

Regards,

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Lindsay_Davies

We may need a little more detail for your real requirements to be able to give the best advice.

How many DataIDs are you talking here?

Connect by prior is used to walk a tree and you can do that up or down the hierarchy.

As you do that, you have access to this pseudo column sys_connect_by_path.

You have a list of (leaf level) documents so would need to walk up the tree, so the string in sys_connect_by_path will be ‘back to front’.

The alternative is the system overload of walking down the tree for a volume to then only select from that whole structure the rows which match your list of DataIDs.

So the number of items in your start list is significant in determining the best approach and also what you want to do with the path information when you have it.

Your current statement ‘start with parentid=-1’ basically says every volume in the system – so I would not want to run that.

For a given DataId, you can use connect_by_path as follows but you get a row for every level of the hierarchy for each document.

select name, sys_connect_by_path(name,':') path, level from dtree connect by prior parentid=dataid start with dataid in (54317, 112099, 280495, 317454)

NAME PATH LEVEL

---------------------------------------- ---------------------------------------------------------------------- ----------

LL91 Admin online extract.pdf :LL91 Admin online extract.pdf 1

Tickets99 :LL91 Admin online extract.pdf:Tickets99 2

ldavies Home :LL91 Admin online extract.pdf:Tickets99:ldavies Home 3

Customer Report- Amgen since 2002.rtf :Customer Report- A since 2002.rtf 1

Folder 2 :Customer Report- A since 2002.rtf:Folder 2 2

Folder 1 :Customer Report- A since 2002.rtf:Folder 2:Folder 1 3

Outer Project :Customer Report- A since 2002.rtf:Folder 2:Folder 1:Outer Project 4

Splashdown_05_06.doc :Splashdown_05_06.doc 1

Tickets99 :Splashdown_05_06.doc:Tickets99 2

ldavies Home :Splashdown_05_06.doc:Tickets99:ldavies Home 3

verifylog1.out :verifylog1.out 1

BB Compound Document :verifylog1.out:BB Compound Document 2

Enterprise :verifylog1.out:BB Compound Document:Enterprise 3

13 rows selected.

Depending on why you wanted the path to the document and how many you are looking for, it may just be simpler to write a “LiveReport:” output format Livereport that lists the individual documents from an in-list of DataIDs.

select %1 from DTree where dataid in (54317, 112099,280495,317454)

%1 = Report Fields

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2013 May 07, Tue 10:34
To: eLink Recipient
Subject: How to display the path of a specific Livelink ID

How to display the path of a specific Livelink ID

Posted bylivelinkadmin@pdo.co.om (Admin, Livelink) On 05-07-2013 05:30

Hi,

I have list of document ids. My requirement is to display the path of those IDs.

Can someone help me on this please?

I used below query. It doesn't help me.

select dataid, name, sys_connect_by_path(name,':') path from dtree where subtype = 144 connect by prior dataid = parentid and dataid in (3987729) start with parentid = -1;

Our database is Oracle 10g

Livelink version 9.7.0

Regards,

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Jean-Philippe_Martin

Take a look at this thread :

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=30178226&objAction=viewincontainer

Basically the DTreeAncestors table could help you do it.

There's also another method which I posted in that thread because I did not knew about dtreeancestors.