top-image

Tag archives for DQL

Documentum : Repeating and Single Value Attributes in Database, Tables, Views, Aspects, i_position

21
Jan
posted by                filed under Database, Documentum, DQL DCTM
Documentum : Repeating and Single Value Attributes in Database, Tables, Views, Aspects, i_position
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»
Tags: , , , , , , , , ,
Comments (0)

Documentum : Job : Force the starting and stopping of a running job (DQL, API)

30
Nov
posted by                filed under API DCTM, Documentum, DQL DCTM, ECM
Documentum : Job : Force the starting and stopping of a running job (DQL, API)
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»
Tags: , , , , , , ,
Comments (0)

Documentum : DQL : Repeating Attribute DM_QUERY_E_REPEAT_REG, DM_QUERY2_E_REPEAT_TYPE_JOIN

22
Nov
posted by                filed under Documentum, ECM
Documentum : DQL : Repeating Attribute DM_QUERY_E_REPEAT_REG, DM_QUERY2_E_REPEAT_TYPE_JOIN
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»
Tags: , , , , ,
Comments (0)
» Newer Entries
bottom-img
Copyright ® 2012 Hüseyin Özveren. No reproduction, even partial, can be used from this site and all its contents including text, documents, images, etc.. without the express permission of the author.