JavaBlog.fr / Java.lu Documentum Documentum : Value Assistance, Mapping VS Custom Object

Documentum : Value Assistance, Mapping VS Custom Object

Hello,
 
It possible to use Documentum in order to supply and store the available values of an attribute for the filling of user via 2 solutions: Value Assistance/Mapping and Custom Object.
 
Here, the hierarchical diagram of Documentum objects : persistent object, dm_user, dm_acl, dm_sysobject, dm_document, ..etc.

 
 
Solution 1 : Value Assistance/Mapping
This solution consists to use the values mapping on the attributes of a custom type like subtype of dm_document.
These values mappings are configurable via COMPOSER:

  • Advantages : Automatically check of data by DCTM that refuses the saving of documents with an incorrect value in single or multi-value metadata
  • Disadvantages: Heaviness through the Composer

 
 
Solution 2 : Custom Object
This solution consists to use Documentum custom object in order to store the available values for an attribute.

  • Advantages : Easy installation and maintenance
  • Disadvantages: No automatic data check by DCTM

 
Example n°1 : the creation of a subtype of « persistent object » (WITH SUPERTYPE NULL) (Generating DQL queries to create a type via “genesis” SAMSON):

01DQL> genesis my_root_persistent_object
02 
03CREATE TYPE my_root_persistent_object (
04i_is_replica BOOL,
05categories CHAR(64) REPEATING,
06type_name CHAR(64),
07is_encrypted BOOL,
08i_vstamp INT)
09WITH SUPERTYPE NULL
10go

 
Example n°2 : the creation of a subtype of « dm_document » (Generating DQL queries to create a type via “genesis” SAMSON):

01DQL> genesis my_root_document_type;
02 
03CREATE TYPE my_root_document_type (
04id_client CHAR(32) REPEATING,
05format INT,
06date_sending DATE,
07date_creation DATE,
08sensibility BOOL,
09refs_operation CHAR(25) REPEATING,
10crm CHAR(35),
11status INT,
12reference CHAR(255),
13comment_hist CHAR(255) REPEATING,
14last_major_version ID,
15srv_dest_temp INT,
16merging_count INT,
17merging_parents_id ID REPEATING,
18comment CHAR(255))
19WITH SUPERTYPE dm_document
20go
21 
22ALTER TYPE my_root_document_type MODIFY
23comment_hist CHAR(512),
24comment CHAR(512)
25go

That’s all!!!

Huseyin OZVEREN

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.

Related Post