Start a new topic
Discussions xDM xDM - Platform Configuration & Administration
Answered

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

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

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 CommentsSorted by Oldest First

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.

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

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'.

Login to post a comment
More topics in xDM - Platform Configuration & Administration
See all 82 topics
Help Desk Software by Freshdesk