Help—Some DQL Queries

Some helpful queries related to alias sets are described here. These queries are based on the information provided in this chapter.

The following query retrieves aliases (names, values, and types) present in an alias set:

SELECT alias_name, alias_value, alias_category
FROM dm_alias_set
WHERE object_name = 'my_alias_set'

The following query retrieves the performer names for an activity:

SELECT performer_name
FROM dm_activity
WHERE object_name = 'Screen Resume'

The following query retrieves the accessor names for permission set templates:

SELECT r_object_id, object_name, r_accessor_name
FROM dm_acl
WHERE acl_class=1