dql for getting value of display order, attribute location of custom attribute

Dear All,

I want a dql for getting the following values of cutom attribute.

I have a custom object type called emc_test and custom attribute called test_comment..

Now I want to see the value of attribute name, display order, attribute location, is attribute repeating, display label, datattype and length for my custom attribute test_comment.

So I wrote the following DQL:

select distinct attr_name, label_text, domain_type, domain_length from dmi_dd_attr_info WHERE attr_name not in (SELECT attr_name FROM dmi_dd_attr_info WHERE type_name='dm_document') and type_name = 'emc_contract'

But I am not able to find out the column name for display order, attribute location, is attribute repeating in the table dmi_dd_attr_info_s.

Kindly let me know which column is used for display order, attribute location, is attribute repeating for my custom attribute.

How can I get my value for display order, attribute location, is attribute repeating for my custom attribute?

Thanks,

Sonu

Find more posts tagged with

Comments

Haroon_A

I know 'is repeating' is stored at the type level (dm_type), and not at dd.

elboukhari

Hi,

i suppose that

Describe <CUSTOM_TYPE> all with locale='all';

can answer a part of your requirement.

you can remove the all ( in bold ) from the quety to get only custom attr

hope this helps