Project child objects...

Message from Sean M Alderman via eLinkGreetings, Can someone give me a brief explanation of the relationship between aproject and it's objects? For instance, a folder's children have theirdtree.parentid set to the parent's dtree.dataid. From what I can tell, items like folders and documents in the root of aproject have their dtree.parentid set to the parent project's dataidexcept it's negative. The variance I've seen here is that any subprojects have their parentid set to the parent's dataid, but thesenumbers are positive. Is this correct? I'm asking because I'm trying to build a program(currently with Perl and DBI) which will recursively sum thedversdata.datasizes of the contents of an object (like a compounddocument, folder, or project. I've already taken care of the folder andcompound doc, but the project structure is giving me some fits.Thanks.-- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795

Find more posts tagged with

Comments

eLink User

Message from Hans Stoop <<A HREF="mailto:hstoop@opentext.com">hstoop@opentext.com> via eLink

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

Sean,

When a project is created, there are two objects created in DTree. One is project as you see in a folder listing and one is the project volume. In order to save space in DTree or not to have to create a separate table that holds the connection between the project object and the project volume, the dataid of the volume is the same as the dataid of the project object, except for the sign.

I hope this makes things clear.

Hans Stoop

--------------
Register your subtypes in the OScript Registry:
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2454603
Consultant Partner Programs Europe
hstoop@opentext.com
+31 23 5652333
http://www.opentext.com/

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Development Discussion
Sent: dinsdag 2 oktober 2001 20:42
To: eLink Recipient
Subject: Project child objects...

Project child objects... Posted by eLink on 10/02/2001 02:41 PM

Message from Sean M Alderman <sean.m.alderman@grc.nasa.gov> via eLink

Greetings,
Can someone give me a brief explanation of the relationship between a
project and it's objects? For instance, a folder's children have their
dtree.parentid set to the parent's dtree.dataid.

From what I can tell, items like folders and documents in the root of a
project have their dtree.parentid set to the parent project's dataid
except it's negative. The variance I've seen here is that any sub
projects have their parentid set to the parent's dataid, but these
numbers are positive.

Is this correct? I'm asking because I'm trying to build a program
(currently with Perl and DBI) which will recursively sum the
dversdata.datasizes of the contents of an object (like a compound
document, folder, or project. I've already taken care of the folder and
compound doc, but the project structure is giving me some fits.

Thanks.
--
Sean M. Alderman
ITRACK Systems Analyst
PACE/NCI - NASA Glenn Research Center
(216) 433-2795

eLink User

Message from Sean M Alderman via eLinkSo, if I'm looking to build a list of all the items in a project I mightdo a query like -select dataid from dtree where abs(parentid) = ;This should give me all objects... folders and sub-projects?eLink Discussion: Development Discussion wrote:> > ------------------------------------------------------------------------> Name: Message Body> Message Body Type: Hypertext Markup Language (text/html)> Encoding: base64-- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795