DQL to list property labels

steven.savini

We have multiple repositories running and our data dictionary configuration out of synch for property labels (display names). For example, we may have changed the label for object_name to "Drawing Number" in repository that manages CAD drawings. I am looking for a quick way to list all properties with both system name and label, rather than clicking through Composer or DA. I know it must be in the data dictionary tables somewhere, but can't seem to find it. Hoping someone's been here already. Thanks.

GinoVicari

Use the below DQL query, just replace the type_name and nls_key with what is appropriate for you.

select attr_name, label_text from dmi_dd_attr_info where type_name = 'dm_document' and nls_key = 'en' order by attr_name;