Special Parameters for Materialized View Update Conditions

The following special parameters are available for expressions in the materialized view update condition.

MV.LastUpdatedTime: This represents the time at which the materialized view for the Data Block was last updated. You can use this value in an condition expression to incrementally update the materialized view with records that have posted to the database since the last materialized view update. For example, the condition below updates the current materialized view with records having a “transaction date” subsequent to the previous materialization.

[transaction_date][is][greater than][MV.LastUpdatedTime]

MV.MaxValue: This represents the maximum value of the field specified in the left-side menu of the materialized view condition. For example, in the condition below, MV.MaxValue represents the maximum value of the 'Total' field.

 

MV.MinValue: This represents the minimum value in the field specified in the left-side menu of the materialized view condition.

<< 6.2.3 Defining a Materialized View Update Condition © 1996-2013 InetSoft Technology Corporation (v11.5) 6.2.4 Filtering Operators >>