Project Report

Peter Stegl

Hello,

I need an report for all document in an project and it's versions.

Any suggestions?

Thank you, Peter

Find more posts tagged with

Comments

Mukesh_Giri

Hi Peter:

Project is nothing but a object which will be stored in dtree table itself with subtype =202.

Try this query out , it will give you the document details under your project.

It is hardcoded " xxxxxx " should be your project's dataid. If you want to choose dynamically use user input 1 as % and may be a container as prompt.

Select Name AS "Doc Name", CREATEDATE, ACT from Dtree where Dataid in (select dataid from DTreeAncestors where DTreeAncestors.AncestorID= xxxxxx and subtype = 144)

Hope it helps.

Quoted peter.stegl@axpo.ch on 10/21/2011 01:12 PM:

Hello,

I need an report for all document in an project and it's versions.

Any suggestions?

Thank you, Peter

Appu_Nair

How about a query based on ownerid?

Also for you to understand Livelink consider all the main things as a volume.For e.g EWS is a volume,PWS is a volume and Project is a volume,recyclebin is a volume,enterprise library applications are volumes.A volume's ownerid is dataid of the container itself and you will have an entry with -1 for parentid and a negative dataid of it to indicate the sub branch.In most connect by prior treatments if had to use abs to crawl the project subtype and that is the resaon for it.dtreeanacestors is much better I beleive.

A volume has a parentid 0f -1 meaning it is the root,you cannot go up dtree anymore.

so if your project dataid is like this is in dtree

select ownerid,parentid,dataid,subtype from dtree where dataid=395715

your descendants would be

select ownerid,parentid,dataid,subtype from dtree where ownerid=395715

find only docs in project

select ownerid,parentid,dataid,subtype from dtree where ownerid=395715 where subtype=144

Just another way and things that I have used before to help ou