
Tag archives for Repeating
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»
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»
