Which table holds the data type for model attributes in Repository schema : Portal

Start a new topic

Which table holds the data type for model attributes in Repository schema

Vinoth KUMAR C

started a topic 3 days ago

Hi All,

We are trying to build a query to details on model entities and its Attribute label Name, Physical Column name, data type and etc., using MTA_ENTITY, MTA_ATTRIBUTE tables, but I couldn't find where the data type for the attributes is stored in repository schema.
Could someone please point me to the correct table to get this details. Thanks.

Vinoth

2 Comments

Toshish Chauhan

said 3 days ago

Hello Vinoth,

Entity attributes info is present in mta_attribute table and form and collection attributes information is present in mta_field. You can try by joining both tables.

Vinoth KUMAR C

said 3 days ago

Hi Toshish,

Thanks for the response.

MTA_FIELD helps with attributes that are part of one of the collections present, but it may not have entries for all the attributes for the Entity that is not present in any of the collections. There are instances where an entity attribute not part of any of the collections.

Appreciate your help and time!

Vinoth