Previous Topic: DELETED Table

Next Topic: DGM Schema

MODIFIED and PROPERTIES Tables

The MODIFIED table exposes all objects that were modified during the session. The PROPERTIES table lists the old and new values for the changed properties on those objects. The following table describes the columns in the MODIFIED table:

Column Name

Data Type

Description

ID@

INTEGER

The ID of the object in the model. This is the short ID of an object, which is unique in the model, but may change from session to session.

TYPE@

INTEGER

The class ID of the object.

NAME

VARCHAR

The name of the object. For a dual object, this will be the logical name.

OWNER_PATH

VARCHAR

A period-separated list of the ownership chain for the object.

The following table describes the columns in the PROPERTIES table:

Column Name

Data Type

Description

ID@

INTEGER

The ID of the object in the model. This is the short ID of an object, which is unique in the model, but may change from session to session.

TYPE@

INTEGER

The class ID of the property modified.

OLD_VALUE@

VARCHAR

A string representation of the old value of the property.

NEW_VALUE@

VARCHAR

A string representation of the new value of the property.

You can use a query similar to the following to see all changed properties during a session.

Example: Query for returning a list of all the properties that changed during a modeling session