Folder path of a document using LiveReports

Hi,We're using SQL Server 2005 and I want to write a LiveReport where I get a dataid of a document and list all the folders from enterprise down to that document. Can anyone help me do this?Thanks in advance.

Find more posts tagged with

Comments

Lee_Butler

Message from Lee Butler <lbutler@resonatekt.com> via eLink

eLink

Hi Imad,

Not sure if you have WebReports available to you – if youdo it’s very easy - [LL_REPTAG=DATAID NODEINFO:PATH /] or [LL_REPTAG=DATAIDNODEINFO:LOCATION /]

Thanks,

Lee.

From: eLink Discussion:Open Text Live Reports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, September 08, 2010 3:26 PM
To: eLink Recipient
Subject: Folder path of a document using LiveReports

Folder path of a document using LiveReports

Posted by iali (Ali, Imad) on 2010/09/08 09:21

Hi,

We're using SQL Server 2005 and I want to write a LiveReport where I get a dataid of a document and list all the folders from enterprise down to that document. Can anyone help me do this?

Thanks in advance.

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Open Text Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Richard_Walker_(rwalker_-_(deleted))

Thanks Lee. Thats perfect.I ended up using the following to remove the name of the document from the path:[LL_REPTAG=DATAID NODEINFO:PATH PATCHANGE:"<?+>:?+":"#1" /]Regards,Imad

Aarti_Passi

Thanks Lee, it worked for me as well.

Regards,

Aarti

Sachin Bum

~SQL Version~

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

WITH FPath(ParentID, DataID, Name, DocName, PathStr) AS
(SELECT ParentID, DataID, Name, Name, CAST ('' as VARCHAR(MAX))
FROM DTreeCore
WHERE DataID = 69474102
UNION ALL
SELECT nplus1.ParentID, nplus1.DataID,nplus1.Name, FPath.DocName,
case when PathStr ='' then (cast(nplus1.Name AS varchar(max))) else (cast(nplus1.Name AS varchar(max)) + ' : ' + PathStr) END
FROM DTreeCore as nplus1, FPath
WHERE FPath.ParentID = nplus1.DataID
)
SELECT PathStr as 'Folder Path', FPath.DocName 'Folder/Document Name'
FROM FPath where FPath.ParentID=-1;

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