Skip to Content
avatar image
Former Member

Information Steward Custom attributes

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 04, 2017 at 03:27 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded