Hi,
I'm trying to get some information from attributs throught a dql and one of the things I want to know is if the attribute is repetitiv, but I don't know how to do it.
The dql that I'm using is:
select distinct ai.r_object_id, ai.attr_name, dc.object_name, ai.is_required, ai.read_only, ai.is_searchable from dm_display_config dc, dmi_dd_attr_info ai where dc.attribute_source='m_image' and dc.object_name not like 'dm_%' and dc.object_name <> 'Project' and dc.attribute_source=ai.type_name and ai.attr_name in (select dc2.attribute_name from dm_display_config dc2 where dc2.object_name=dc.object_name and dc.attribute_source=dc2.attribute_source and ai.nls_key='es' );
So, I get the object_id, the name of the attribute, if is required, read only an searchable. But I don't know how to know if it is also repetitiv.
Does anybody know how to get this information?
Thanks!
