LiveReport for display documents in a specific folder and it's sub folders...

I am looking for a LiveReport for display documents in a specific folder and it's sub folders or similar to this using MS SQL.

Find more posts tagged with

Comments

Chris_Gaine

Here is a query I use for Oracle.SELECT * FROM DTree d START WITH d.DataId = %1 CONNECT BY PRIOR DataId = ParentIdThen just add a NodeId input and make is a user input parameterI don't think syntax works for SQL Server but check out this link.

Chris_Gaine

Sorry here is the linkhttp://msdn.microsoft.com/en-us/library/ms186243.aspx

Jim_Coursey

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

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

SQL Server doesn't do "CONNECT BY PRIOR". You have to code your own structure walker

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, May 06, 2008 10:25 AM
To: eLink Recipient
Subject: Re LiveReport for display documents in a specific folder and it's sub folders...

Re LiveReport for display documents in a specific folder and it's sub folders...		Posted by cgaines (Gaine, Chris) on 05/06/2008 10:20 AM
In reply to: LiveReport for display documents in a specific folder and it's sub folders...		Posted by khurramamin (Amin, Khurram) on 05/05/2008 06:44 PM

Here is a query I use for Oracle.

SELECT *
FROM DTree d START WITH d.DataId = %1 CONNECT BY PRIOR DataId = ParentId

Then just add a NodeId input and make is a user input parameter

I don't think syntax works for SQL Server but check out this link.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

For instructions on accomplishing this using SQL Server, see:

https://knowledge.opentext.com/knowledge/llisapi.dll/open/11725974

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, May 06, 2008 10:31 AM
To: eLink Recipient
Subject: RE Re LiveReport for display documents in a specific folder and it's sub folders...

RE Re LiveReport for display documents in a specific folder and it's sub folders...		Posted by grmmun02user8 (Coursey, Jim) on 05/06/2008 10:31 AM
In reply to: Re LiveReport for display documents in a specific folder and it's sub folders...		Posted by cgaines (Gaine, Chris) on 05/06/2008 10:20 AM

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

SQL Server doesn't do "CONNECT BY PRIOR". You have to code your own structure walker
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, May 06, 2008 10:25 AM
To: eLink Recipient
Subject: Re LiveReport for display documents in a specific folder and it's sub folders...

Re LiveReport for display documents in a specific folder and it's sub folders...		Posted by cgaines (Gaine, Chris) on 05/06/2008 10:20 AM
In reply to: LiveReport for display documents in a specific folder and it's sub folders...		Posted by khurramamin (Amin, Khurram) on 05/05/2008 06:44 PM

Here is a query I use for Oracle.

SELECT *
FROM DTree d START WITH d.DataId = %1 CONNECT BY PRIOR DataId = ParentId

Then just add a NodeId input and make is a user input parameter

I don't think syntax works for SQL Server but check out this link.

Michael_Heisch_(sglcadmin12_-_(deleted))

this statement can be use to display / search documents and (sub-) folders from a specific (parentid) starting pointwith dtree_cte (dataid, parentid) as (select dataid, parentid from livelink.DTree where parentid in (12345)union allselect e.dataid, e.parentid from livelink.dtree as e join dtree_cte as mon e.parentid = m.dataid)select dataid, parentid from dtree_cteworks only for SQL Server 2005Best regards Christian Rochlitz