
Tag archives for DQL
Hello,
This post is relating to repeating and single attributes in underlying database. Documentum objects support 2 types of attributes:
Single Value Attributes
Single Value properties are properties that can hold a single value at a time like the attributes r_object_id, object_name,...etc.
Repeating Attributes
Repeating Attributes are properties that can hold multiple values like the attributes Keywords, i_folder_id, r_aspect_name...etc.
TABLES
All objects/properties/attributes are saved in underlying database. ...more»
Hi,
Just a post in order to expose a solution in order to force the starting/stopping of a running job.
Force the job's starting via DQL:
Execute the following query:
Check the log and the automatically setting to initial value for the next invocation date by AGENT_EXEC process depending on the scheduling parameters of job :
Force the job's stopping:
Get the process id, by running ...more»
Hello All,
I am running the below query in order to list the documents created after 23/09/2015, whose the name starts with 'javalu' and attached/associated with the ASPECTS aspect_1 or aspect_2:
NOTE : r_aspect_name is repeating attribute.
SELECT doc.r_object_id, doc.r_aspect_name
FROM dm_document doc
LEFT OUTER JOIN dm_acl mAcl ON mAcl.object_name = doc.acl_name
WHERE LOWER(doc.object_name) like 'javalu%'
AND (any doc.r_aspect_name = 'aspect_1' or any doc.r_aspect_name = ...more»
