Problem while retrieving default values for custom attribute.

Hi ,

I am tryin gto retrieve the default values defined for a custom attribute using following dql -

select r_object_id, default_value from dmi_dd_attr_info where type_name = ' my_test ' and attr_name = ' test_attri5 ' ;

i am getting some values in default values column but they are in some id format..

i am not getting the actual values which i have set as defalut values.

r_object_id

default_value

================ ================

6a003fd18000f908 53003fd180006d1e

53003fd180006d1d

i cannot figure out what i am doing wrong.

Any help on this.

Thanks

Find more posts tagged with

Do a API dump for the object: 53003fd180006d1e

This will tell you what object type this is and you will probably have to do sub-select or join to get the default value.

Thanks Johnny for replying..

actually i have modified my query and i am getting the default values..

select r_object_id, default_expr_value from dmi_dd_attr_info where type_name = ' my_test ' and attr_name = ' test_attri5 ;

but the only problem i am facing is that the first row return the null value every time i.e

if there are two default values has been set for attribute i am getting three rows through query..

the first one is null, if there are no default values for any attribute then also it gives me back one row with

null value. The same happens in case of system defined attributes also like authors, title etc

What could be the possible reason this is happening?

Thanks

NULL value is results of how Content Server handles repeating values. Try adding ENABLE(ROW_BASED) at the end of your query.