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

Start a new topic

Answered

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

Vinoth KUMAR C

started a topic almost 2 years 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

Best Answer

Alexia SIMOND said over 1 year ago

Hello Vinoth,

Table columns are also stored in this MTA_FIELD table.

If you want to exclude collection and form fields, then you need to apply a filter on classname = 'TableColumn'.

3 Comments

Toshish Chauhan

said almost 2 years 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 almost 2 years 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

Alexia SIMOND

said over 1 year ago

Answer

Hello Vinoth,

Table columns are also stored in this MTA_FIELD table.

If you want to exclude collection and form fields, then you need to apply a filter on classname = 'TableColumn'.