Secondary table properties

FilterClause

Collection of filter criteria to filter the data returned by the view table. Examples

• Sample period={Current Production Shift} or Sample period={12-02-2009}

• fieldname={filter}, fieldname={filter}

The filter clause supports syntax as defined in filtering rules.

For Inventory views, you can set the valid time period with the FilterClause property.

@GroupBy=[Calendar.Day} or @GroupBy={Calendar.Hour}

Custom views are considered server-side filtering and therefore must take the invariant version of filtering.

• Invariant form

• Uses Field Name instead of Display Name

• Uses ISO 8601-compliant UTC dates

Field Name={Filter Criteria}, Another field={Other Criteria}

JoinFields

Indicates the join fields for this secondary table. A join field connects the secondary table to the primary table.

JoinType

The join type between the primary and secondary table.

When the join type is Inner, all data from the Primary table is included in the custom view, and only data from the secondary table that matches on join fields.

When the join type is Outer, all data in both tables is present in the Custom view.

• Inner: You can group on fields that originate from the Primary table.

• Outer: You can group on fields that originate from the Primary table and the Secondary table.

Inner, Outer

ModuleDescriptor

The AVEVA Production Management module from which the source data for the view is derived.

SourceData

The collection of source data for a view table.

Click Browse (...) to open the Select SourceData dialog box. The hierarchy presents a list of valid data source locations. Choose one or more locations and click OK.

StandardView