LiveReport with Folder Creator and Owner

I am trying to get a report to give me folder names, the creator and owner. Most of the time Creator and Owner are the same so I do need the Owner. I cannot find an " owner " variable. I would think it would be in the DTree table. So far this is what I have:select DISTINCT g.Name, g.createdby, l.lastname, l. Firstname from DTree g, kuaf l where g.createdby = l.ID and SubType = 0 order by g.Name

Find more posts tagged with

Comments

Neil_Sampson

Message from Neil Sampson via eLinkTry DTREEACL table, for owner there are two per item, Owner and OwnerGroup.I think Owner is ACLTYPE=1 and OwnerGroup is ACLTYPE=2Hope this helps-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 06 December 2006 16:01To: eLink RecipientSubject: LiveReport with Folder Creator and OwnerLiveReport with Folder Creator and OwnerPosted by Treger, Ann Marie on 12/06/2006 11:00 AM I am trying to get a report to give me folder names, the creator andowner. Most of the time Creator and Owner are the same so I do need theOwner. I cannot find an " owner " variable. I would think it would bein the DTree table. So far this is what I have:select DISTINCT g.Name, g.createdby, l.lastname, l. Firstname from DTreeg, kuaf l where g.createdby = l.ID and SubType = 0 order by g.Name[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Ann-Marie_Treger

Thanks that helped. My LiveReportnow gives me the owner of the folder which is exactly what we need to see who controls the folder. The Owner can change which is what we to keep track of whereas the creator does not change. Creator is the owner until the owner gets changed . One more thing, can I limit the folders to a high level ? The Enterprise and one or two paths below would be great. LiveReport for Owner:select DISTINCT g.Name, l.LastName "Owner Last Name" , l. Firstname "Owner First Name" from kuaf l, DTree g, DtreeACL k where g.dataID = k.dataID and l .ID= k.rightId and g.SubType = 0 and k. ACLtype=1 order by g.Name

Adeiza_Yisa

Hello Marie,

I am glad you have your LiveReports working now. However, I need to do a smilar thing but want the information only for a specifc folder. In other words, I want to see all the sub-folders and their owners under a specified folder.

Anyone has an idea of how to do this.

Warm regards,

Adeiza, Nigeria LNG