Skip to Content
0

Information Steward Custom attributes

Feb 15, 2017 at 07:49 AM

93

avatar image
Former Member

Hi

Is there a link table in the Information Steward repo that has a link between rules and new custom attributes that were added and assigned to the rule?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Adrian Storen Sep 04, 2017 at 03:27 AM
0

Yes. Here are the tables:

MMT_CUSTOM_FIELD (or MMB for the current record version) stores all custom attributes

MMT_CUSTOM_FIELD_VALUE (or MMB for the current record version) stores all custom attribute values for each custom attribute

MMT_RELATIONSHIP (or MMB) stores the relationship. Join on MMT_CUSTOM_FIELD_VALUE.table_id to MMT_RELATIONSHIP.table_id and MMT_CUSTOM_FIELD_VALUE.object_id = MMT_RELATIONSHIP.related_object_id.

MMT_DATA_GROUP (or relevant MMB eg MMB_BUSINESS_CATEGORY for categories) stores the target relationship. Join MMT_DATA_GROUP.data_group_id = MMT_RELATIONSHIP.object_id. Use MMT_RELATIONSHIP.related_table_id to find out the related table by looking up MMT_TABLE as it lists the table types (ie what related/table_id means in MMT_RELATIONSHIP)

Share
10 |10000 characters needed characters left characters exceeded