LiveReport-- Group Permissions in CS only on Top Level Folder/Documents

I need to find out if a group has permission on Folder and Documents but it should only return Top folder where it has permission. I am doing this in SQL

Ex:-

1. If There is a folder structure Folder_A-->Folder_B-->Folder_C and A group "GroupH" is applied to all down to tail From Folder_A to Folder C, it should only return Folder_A with Group Name

2. If Any document reside another location in CS and has perticularly this group permision (doesn't inherit from any where), that should also be display

I have created a query which list all the data but not sure how to filter this.

----------------------------------------------------

select distinct D.Name,DA.DataID,DTA1.AncestorID,DTA1.AncestorID
from
awcs.DTreeACL DA,
awcs.DTree D,
awcs.DTreeAncestors DTA,
awcs.DTreeAncestors DTA1
where DTA.DataID=DA.DataID and DTA.DataID=D.DataID and DA.RightID=<GroupID>and DA.DataID=DTA1.AncestorID
order by Name

Find more posts tagged with

Comments

Colin_Schmidt

That query will return all Folders with the Group ID in the Permissions and I don’t know of another way to exclude SubFolders from the Top most that is found. Even a Sub-Folder would be an ANCESTORID. There might be a way to do this with a UNION gathering In Folders-only. The ID itself could be in any sequence, so depending upon the sequential state of this number could be wrong.

You’d have to determine the hierarchy of any folder structure and then discard all but the top. You may have to have two reports: 1 for Folders and 1 for all other.

If the EWS is large, this could run for some time. There could be several hundred million or more entries.

There are only two indexes to the DTREEACL table: PARENTID & DATAID.

It might also be faster going from the DTREE to the DTREEACL, since there can be many-to-one ACL records per Object, matching on DataID qualifying with the GroupID.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, August 04, 2016 4:45 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: LiveReport-- Group Permissions in CS only on Top Level Folder/Documents

LiveReport-- Group Permissions in CS only on Top Level Folder/Documents

Posted by Walia, Abhimanu On 08/04/2016 04:40 AM

I need to find out if a group has permission on Folder and Documents but it should only return Top folder where it has permission. I am doing this in SQL

Ex:-

1. If There is a folder structure Folder_A-->Folder_B-->Folder_C and A group "GroupH" is applied to all down to tail From Folder_A to Folder C, it should only return Folder_A with Group Name

2. If Any document reside another location in CS and has perticularly this group permision (doesn't inherit from any where), that should also be display

I have created a query which list all the data but not sure how to filter this.

----------------------------------------------------

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

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

eLink User

Both SQLserver and Oracle has psuedo columns.In oracle one can use 'Level' to target a hierarchy position in a query.I think dtreeancestors can probably be joined to indicate a level as well.

I have not done this but I have done pl/sql that can use levels in connect by queries. Dbrowseancestors may have what you are looking for possibly.

..... appnair appunair( Livelink Rocks )

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Thu, Aug 4, 2016 at 8:43 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE LiveReport-- Group Permissions in CS only on Top Level Folder/Documents Posted bySchmidt, ColinOn 08/04/2016 09:42 AM

That query will return all Folders with the Group ID in the Permissions and I don’t know of another way to exclude SubFolders from the Top most that is found. Even a Sub-Folder would be an ANCESTORID. There might be a way to do this with a UNION gathering In Folders-only. The ID itself could be in any sequence, so depending upon the sequential state of this number could be wrong. You’d have to determine the hierarchy of any folder structure and then discard all but the top. You may have to have two reports: 1 for Folders and 1 for all other. If the EWS is large, this could run for some time. There could be several hundred million or more entries. There are only two indexes to the DTREEACL table: PARENTID & DATAID. It might also be faster going from the DTREE to the DTREEACL, since there can be many-to-one ACL records per Object, matching on DataID qualifying with the GroupID. Colin J. SchmidtKnowledgelink SupportCapitalOne | Collaboration Technology

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, August 04, 2016 4:45 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: LiveReport-- Group Permissions in CS only on Top Level Folder/Documents

LiveReport-- Group Permissions in CS only on Top Level Folder/Documents

Posted by Walia, Abhimanu On 08/04/2016 04:40 AM

I need to find out if a group has permission on Folder and Documents but it should only return Top folder where it has permission. I am doing this in SQL
Ex:-
1. If There is a folder structure Folder_A-->Folder_B-->Folder_C and A group "GroupH" is applied to all down to tail From Folder_A to Folder C, it should only return Folder_A with Group Name
2. If Any document reside another location in CS and has perticularly this group permision (doesn't inherit from any where), that should also be display
I have created a query which list all the data but not sure how to filter this.
----------------------------------------------------
select distinct D.Name,DA.DataID,DTA1.AncestorID,DTA1.AncestorID
from
awcs.DTreeACL DA,
awcs.DTree D,
awcs.DTreeAncestors DTA,
awcs.DTreeAncestors DTA1
where DTA.DataID=DA.DataID and DTA.DataID=D.DataID and DA.RightID=<GroupID>and DA.DataID=DTA1.AncestorID
order by Name
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center

[To post a comment, use the normal reply function]
Topic:	LiveReport-- Group Permissions in CS only on Top Level Folder/Documents
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Alister Grigg

You mean a view like the attached one? This will do what you want and a lot more. If you want access to this tool for your client you can get it through Jitendra Desai (Jitendra.Desai@cognizant.com) in your Virginia office.

Filtered View One Group Top Level Only.png