Useful DQL Queries: Documents

List all documents owned by a specific user:

select object_name from dm_document where owner_name =
‘Carlo’

List all documents that contain specific keywords:

select object_name from dm_document where any keywords
= ‘scientific’ and any keywords = ‘equipment’

List all documents that have been checked out since yesterday, and who checked them out:

select object_name, r_lock_owner from dm_document
where r_lock_date >= DATE(YESTERDAY)

List all attributes of a specific type, indicating which are repeating-valued (1=repeating):

select attr_name,attr_repeating from dm_type where
name = ‘dm_document’

Identify the supertype of a specific type:

select super_name from dm_type where name = ‘dm_cabinet’

List all subtypes of a specific type:

select name from dm_type where super_name = ‘dm_sysobject’

List the names of all types in the repository:

select name from dm_type

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: