CODEWITHSUNDEEP
dqldocumentum
Ryan Williams
Ryan Williams

Reputation: 663

How to return cabinets not including hidden ones with DQL

I'm trying to return all the cabinets on a repository in documentum but I don't want to include cabinets not viewable from the DA, something like

   select object_name from dm_cabinet where (hiddenAttribute = "false")

or 

   select object_name from dm_cabinet where permissions > 4

in the documentation 

  select object_name from dm_cabinet

is suppoed to return a list of all cabinets (including private) im trying to only return non private cabinets

Upvotes: 0

Views: 2093

Answers (2)

Ryan Williams
Ryan Williams

Reputation: 663

I guess the query I was looking for was

  "select * from dm_cabinet where (a_is_hidden = 0 and is_private = 0) or (any r_folder_path in (select default_folder from dm_user where user_name = '" +
                    username + "'))";

this query mimic's the DA and returns only the cabinets that a user see's when logged into the DA

Upvotes: 0

Miki
Miki

Reputation: 2517

select object_name from dm_cabinet where is_private = 0

In general there is no built in hidden property within Documentum types. However, dm_cabinet is an exception from this rule. It has property is_private which is used to determine whether you can see or access this cabinet with client applications. Only owners are able to see their cabinets -> link.

Speaking of objects in general you won't see it if you have permission NONE(1), i.e. if you by name or group membership aren't listed with higher privilege than none.

Documentum has built in "group" dm_world which is used for representing users that aren't declaratively mentioned in permission set for specific object. By default this group has READ (3) permission for generic permission sets.

Upvotes: 3

Related Questions