Live Report to find the subprojects in a project and the items present in the sub project.

Hi All,

I have a requirement to generate a livereport, to find the sub projects in a project and the items present present in the sub projects.

Suppose there is a project called A

and sub project B and C in A

and sub project B has folder f1 and f2

and folder f1 has sub folder sf2 and some documents in sub folder sf2....

and the same will be for sub project c.

If I execute this report it should give me the report as

sub project name,folder name,document

Here sub project name should be B,

folder name that is the immediate folder sf2,

The document is the first document present inside the folder sf2.

This is the query I have started with.

WITH n(DataID, ParentID,Name,subtype,createdate,userid) AS (SELECT d.DataID, d.ParentID, d.Name,d.subtype,d.createdate,d.userid FROM Dtree d WHERE parentid = 1201519)

SELECT * from n

Need help ASAP...It will be very much appreciated.

Find more posts tagged with

Comments

Ravichandran Sukumar

Quoted Ravichandran Sukumar on 2013-02-08 16:32:

Hi All,

I have a requirement to generate a livereport, to find the sub projects in a project and the items present present in the sub projects.

Suppose there is a project called A

and sub project B and C in A

and sub project B has folder f1 and f2

and folder f1 has sub folder sf2 and some documents in sub folder sf2....

and the same will be for sub project c.

If I execute this report it should give me the report as

sub project name,folder name,document

Here sub project name should be B,

folder name that is the immediate folder sf2,

The document is the first document present inside the folder sf2.

This is the query I have started with.

WITH n(DataID, ParentID,Name,subtype,createdate,userid) AS (SELECT d.DataID, d.ParentID, d.Name,d.subtype,d.createdate,d.userid FROM Dtree d WHERE parentid = 1201519)

SELECT * from n

Need help ASAP...It will be very much appreciated.

The query should be in Microsoft SQL.

Thetheeee

Lindsay_Davies

Hi,

This is not a simple thing to do.

A project object is created in a workspace such as Enterprise.

The project object has a separate workspace object with a DataID that is the negative of the Project object’s DataID.

All its files and folders live in that Project workspace.

BUT sub-projects are children of the Project object back in the original [Enterprise] workspace.

As projects they each have their own workspaces.

If you want to mix lists from multiple projects, the likelihood is that when you get your statement to work correctly you will have created a list of items that is very long and hard to display meaningfully to an end user.

If you are in a rush, there is a function request Projects.ProjectOutline that will help with the simple display of items within a given Project workspace.

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2013 February 08, Fri 11:08
To: eLink Recipient
Subject: Live Report to find the subprojects in a project and the items present in the sub project.

Live Report to find the subprojects in a project and the items present in the sub project.

Posted byravichandran.s29@wipro.com (Sukumar, Ravichandran) On 02-08-2013 06:02

Quoted Ravichandran Sukumar on 2013-02-08 16:32:

Hi All,

I have a requirement to generate a livereport, to find the sub projects in a project and the items present present in the sub projects.

Suppose there is a project called A

and sub project B and C in A

and sub project B has folder f1 and f2

and folder f1 has sub folder sf2 and some documents in sub folder sf2....

and the same will be for sub project c.

If I execute this report it should give me the report as

sub project name,folder name,document

Here sub project name should be B,

folder name that is the immediate folder sf2,

The document is the first document present inside the folder sf2.

This is the query I have started with.

WITH n(DataID, ParentID,Name,subtype,createdate,userid) AS (SELECT d.DataID, d.ParentID, d.Name,d.subtype,d.createdate,d.userid FROM Dtree d WHERE parentid = 1201519)

SELECT * from n

! Need help ASAP...It will be very much appreciated.

! The query should be in Microsoft SQL.

Thetheeee

[To post a comment, use the normal reply function]
Topic:	Live Report to find the subprojects in a project and the items present in the sub project.
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Ravichandran Sukumar

Thanks for the help Lindsay...