Tag archives for Repeating

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»
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»
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.