Value Assistance help?

fsudrew

We are populating a data drop down list and pulling keys and values from a registered table. For example,

LU_STATE

STATE_ID      STATE_DESC

1                     VA

2                     TX

3                     FL

4                     GA

5                     ...

When the drop down list is saved the state_id is stored in Documentum repository. When a user performs searches for a specific state the correct results are not returned properly, since we have not customized search yet.  What is a good approach in be able to give the user the cability to search the STATE_DESC field? Can someone give me a good example?

lastnitescurry

Assuming it can be done.... and I am curious to try it the next time I have the need, I would do

OPTION 1

* Figure out the DQL statement to add key/ & display value, value assistance for an attribute

* Write a data dictionary population script to, populate all the values of the registered table in data dictionary

** Use Job & Method if registered table would change often

* Configure attribute to use Data Dictionary value assistance

OPTION 2

* Custom script to create a custom data ditionary population file, based on MAPPING_TABLE format for r_accessor_permit for dm_acl in file

$DM_HOME$\bin\data_dictionary_en.txt

* Install this config file into repository

* And in your case, remove all customisations around this attribute