How to access information of Data Dictionary ?

sagar.singh

hello all.

I am new to documentum and specially have no idea about the data dictionary.

Now I need to access information from data dictionary about a particular object type in docbase.

Please suggest me how can i do it (preferably using DFC ).

Thanks in Advance

Sagar Singh

Find more posts tagged with

Comments

Francois Dauberlieu

What information do you need, it might be something that's already automatically fetched by something else.

Let us know and we'll see what pointers we can give you

PK4D

You can execute DQL queries using DFC. You can query the types named dmi_dd_*. Look at the object reference for information about these types and how they represent data dictionary.

sagar.singh

Hello ,

Actually i want have to update attributes of a particular object type (say obj_type). Now i might be having some mandatory attributes in this object type. I only wants to update attributes if all the mandatory attribuites's values are provided. if even a single mandatory attribute value is not provided then NONE of the attribute will be updated.

Hope this information will help.

Sagar Singh

Francois Dauberlieu

Why would you bother with the data dictionary ? You can use Developer Studio to update a type

PK4D

I think he is talking about updating the attribute values in an object (as opposed to modifying the type itself). Secondly, this needs to happen in application code where values for attributes are being received and need to be validated against the specs.

Since the information about a attribute being required is stored in dmi_dd_attr_info.is_required a lookup of data dictionary is required. You can use the following sample code (from DFC Javadoc samples) to perform all DD validation. For other specific validation options please see the IDfValidator interface JavaDocs.

<![CDATA[
    IDfPersistentObject pObj = null;
    IDfValidator v = null;
    try {
        IDfId objId = m_clientx.getId("09...1");
        pObj = m_sess.getObject(objId);
        pObj.setInt("int_attr", 6);	// Modifying the attr here...
        v = pObj.getValidator();
        v.validateAll(null,true);
    }
    catch(DfValidationException ve) {
        // Validation rules violated...
    }
]]>

sagar.singh

Hello All,

I am using following code for the above purpose (wonder if I am going in a right direction or not)

DQL : *select attr_name, is_required from dmi_dd_attr_info where type_name = 'abcd' *

This DQL is returning the result :

attr_name	is_required
i_has_folder	0
i_folder_id	0
r_composite_id	0
r_composite_label	0
r_component_label	0
r_order_no	0
r_link_cnt	0
r_link_high_cnt	0
r_assembled_from_id	0
r_frzn_assembly_cnt	0
.............	...............

I am confused whether "0" denotes mandatory or non-mandatory attribute..

One more confusion every row returned with this query has is_required value as "0"

PK4D

1 denotes required. It is just that there are a lot more attributes that are not set as required. You can try with altering your where clause to include is_required = 1.

sagar.singh

Hello All,

I am still unable to find the solution of the problem.

My problem is like this :

I have to import document (using a utility developed by ourselves ) of type dm_document
Attribute's values related to this document is provided using a different metadata file (excel).
This import process should only be successful if the values of all the mandatory attribute like object_name etc are provided into metadata file.
If i am using dmi_dd_attr_info table to find the mandatory attributes using the DQL
The result returned by query suggest that object_name is not mandatory

SELECT attr_name, is_required FROM dmi_dd_attr_info WHERE type_name='abcd' AND is_required != 0

gives result

attr_name	is_required

{ 0 rows affected }

how can i get the information that tells me that object_name is mandatory ??

sagar.singh

I wonder if dmi_dd_attr_info provides the correct information.

If i am using the following query

select distinct attr_name, is_required from dmi_dd_attr_info where type_name ='dm_user' AND attr_name IN ('user_name' , 'user_login_name')

Its is giving following results:

attr_name......is_required

user_login_name.......0

user_name...............0

This result shows that user_login_name and user_name are NON-MANDATORY attributes but these are mandatory attribute infact.

How can i get the the mandatory attributes of dm_user (or any other object type ) ?

JosePGisone

I believe that in this case, the DA / Webtop / WDK GUI has built-in rules that make those attributes mandatory; these rules are not being derived after the application has consulted with the Data Dictionary.

This is just a hunch - I have not confirmed this.