Thursday, September 24, 2009

How to find/get the list of values of the attribute or the query string of the attribute?

1. Get the value of the i.cond_value_assist like below:

select distinct i.attr_name, i.cond_value_assist from dmi_dd_attr_info i, dm_type t where i.attr_name=t.attr_name and i.type_name='' and t.name='' and t.i_position < (t.start_pos * -1) enable (row_based)

2. select default_id from dm_cond_id_expr where r_object_id='value of the i.cond_value_assist '

3. If the value of the default_id starts with "5c", then the attribute has the value assistance query:
select r_object_id, query_string from dm_value_query where r_object_id='value of the default_id'

4. If the value of the default_id starts with "5b", then the attribute has list of values as value assistance:
select r_object_id,valid_values from dm_value_list where r_object_id='value of the default_id'