Root folder -1 or -2

Livelink 9.7.1, Oracle

Hi,

I am writing a report where I need have a column 'Root folder -1 or -2 ' e.g. Enterprise folder's child folder name or 2nd child folder name. My report already have DATA ID column.

Please do let me know what is the way for that.

Best regards,

Baber Amin.

Find more posts tagged with

Comments

Lindsay_Davies

Hi Baber,

That depends on how you are currently building your query to get your current set of rows.

You would either need to join to DTree again or if you are already using a ‘connect by prior’ construct to walk the hierarchy, you could probably pick the information up with a pseudo column

What version of Oracle are you using?

Can you share the relevant part of your query?

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2014 February 09, Sun 10:44
To: eLink Recipient
Subject: Root folder -1 or -2

Root folder -1 or -2

Posted bybaber.amin@dolphinenergy.com (Amin, Baber) On 02-09-2014 05:39

Livelink 9.7.1, Oracle

Hi,

I am writing a report where I need have a column 'Root folder -1 or -2 ' e.g. Enterprise folder's child folder name or 2nd child folder name. My report already have DATA ID column.

Please do let me know what is the way for that.

Best regards,

Baber Amin.

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

Baber_Amin

Hi,

we are using Oracle 11g.

Query as below:

select DISTINCT da.dataid, dv.filename, dv.filecdate, da.auditdate,dv.datasize/(1024*1024) "File Size MBs", (select name from kuaf where id=PERFORMERID) "User",

(select officelocation from kuaf where id=PERFORMERID) "Officelocation"

from dauditnew da, dversdata dv

where

(

(select upper(officelocation) from kuaf where id=PERFORMERID) like upper('%ABC%')

OR (select upper(officelocation) from kuaf where id=PERFORMERID) like upper('%XYZ%')

)

and auditstr in ('Fetch', 'View') and (auditdate>='01-JAN-2014' and auditdate<='01-FEB-2014')

and da.dataid=dv.docid and da.value1=dv.versionname

order by dv.datasize/(1024*1024) desc;

Lindsay_Davies

Hi Baber,

I am not too sure what your aim is with your report.

It looks like you are trying to report on ‘usage’ for items in the top two levels of the Enterprise within a given period.

Is that right?

Starting with your current query, you would need to add a join to DTree to get the parentID of the DataID from DAuditNew

and then an additional join to DTree again to be able to look up the name of the parent container.

That would be very inefficient.

As it is, you will get a lot of rows back with this query.

Were you going to also apply a group by clause to summarise some of the output?

I think you need to re-think and start by recursing DTree for the top two level folders in the Enterprise.

Use connect by prior and limit using ‘level’.

That would build a set of DataIDs with names and parentage that you can then check in DAuditNew to filter by who access them etc.