LiveReport query to find the list of sub folders under one specific folder

Hi all,

I need a simple query (simple for others than me as I am not familiar at all with Livelink Tables and sql language) to get this :

List of SubFolders Name + SubFolders Data ID under one specific folder (Folder IS = 6421105)

Please help me.

Find more posts tagged with

Comments

Greg_Griffiths

Lionel,

you have not indicated which version of Livelink and which database you have etc, but at the simplest level you can do the following

// get all folders that are direct children of node 1234

SELECT * FROM dtree WHERE subtype=0 AND parentid=1234

if you are after direct and indirect folders then you will need to add a join to the DTREEANCESTORS table or create a cyclic query - using CONNECT BY in Oracle or a CTE in SQL Server.

If you speak to OpenText they can provide you with the schema document, once you have signed an NDA, and they also provide a very good Schema and LiveReports course (http://www.opentext.com/training/coursedetails.html?id=1529) too.

Thierry_FROMENTIN

It perfeclty suits me. Thank you so much.

Colin_Schmidt

A folder is a subtype = 0, so you would set up your LR to either prompt for the DataID(number) of the Parent folder or a prompt that would allow you to browse a Container. If you have Oracle, get SQL Developer from them. It's free. it'll allow you to see the tables (if you know the same ID & Password) CS is using. If not, have the DBA create an ID that views the same tables.

The code would look like this in Oracle:

select dt.dataid, dt.name "Parent", dt1.dataid, dt1.name, dt1.childcount

from dtree dt

join dtree dt1 on dt.dataid = dt1.parentid and dt1.subtype = 0

where dt.dataid = %1

Colin J.

On Mon, Dec 9, 2013 at 5:58 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

LiveReport query to find the list of sub folders under one specific folder Posted bylionel.lefloch@loreal.com (LEFLOCH, Lionel)On 12-09-2013 05:54

Hi all, I need a simple query (simple for others than me as I am not familiar at all with Livelink Tables and sql language) to get this : List of SubFolders Name + SubFolders Data ID under one specific folder (Folder IS = 6421105) Please help me.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.