Alexander Zuban’s Homepage

The other simple customization you may do with the Application Builder this is

Manage attributes which were visible on the property mask

To do this edit selected type and navigate to “Display Configuration” tab. And just add attributes you want to see.

NOTE: That you need to manage visible attributes for each client scope, so Webtop and Desktop Client may have different set of visible attributes.

Also you may add more tabs to group attributes according to some logic.

After these simple steps you will get the following results.

• New Document
  
• Properties - “Info Tab” with customized attributes
  
• Properties - Additional Custom Tab
  

Notice, that you make this job without single line of code!

Provide list of available values for the user

The other things you may do to be more attentive to your users this is provide them with a list of possible values. I write some about in Data Forest post. To do this you need to edit target attribute and navigate to “Value Assistance” tab.

Several options available as a source for the available values.

Fixed List - this is the simplest way; it is suitable for the limited and non changeable values (e.g. Country regions, Time Zones, Object States, abbreviations). All you need in this case - just add each value in a single line.

Query - this option allow specify a query to populate list of values. If your user don’t need to edit list of possible values often you may use registered table in other case it is better to create a folder structure and populate values as a folder names or other attributes. Also with this way you may show value from one attribute (table field) but save value from other attribute. This is comfortale when you have list of abbreviations which is hard to remember, so you may show description, but store abbreviation itself.

NOTE: For each option you may specify that list not complete, so in this case Webtop/Desktop will allow adding value different to values in the list, in other case this will be not possible.

Here is a template DQL to create a registered table in DB and Documentum. You may execute it with idql32 command line tool or with the Documentum Administrator DQL executer.

1.  
2. #Enable this lines if you run this script several times
3. #execute exec_sql with query = 'DROP TABLE reg_invoice_type';
4. #go
5.  
6. #this statement create table in the DB schema, note, that raw SQL used here, so this part dependents from DB
7. execute exec_sql with query='
8. CREATE TABLE reg_invoice_type(
9. invoice_type varchar2(5),
10. invoice_type_info varchar2(30)
11. )'
12. go
13.  
14. #Enable this lines if you run this script several times
15. #unregister table reg_invoice_type
16. #go
17.  
18. #register object in Documentum
19. register table dm_dbo.reg_invoice_type
20. (
21. invoice_type char(5),
22. invoice_type_info char(30)
23. )
24. go
25.  
26. #setup table permissions
27. update dm_registered object set owner_table_permit=15 where object_name='reg_invoice_type'
28. go
29. update dm_registered object set group_table_permit=1 where object_name='reg_invoice_type'
30. go
31. update dm_registered object set world_table_permit=1 where object_name='reg_invoice_type'
32. go
33.  
34. #fill table with values
35. INSERT INTO dm_dbo.reg_invoice_type(invoice_type,invoice_type_info)
36. VALUES ('T1','Loan Bill')
37. go
38.  
39. INSERT INTO dm_dbo.reg_invoice_type(invoice_type,invoice_type_info)
40. VALUES ('T2','Utility Bill')
41. go
42.  
43. #test the values
44. select * from dm_dbo.reg_invoice_type
45. go

Wow, here is a result, now your uses for sure will not make any typo mistake.