Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Production Management

Configure the primary table

  • Last UpdatedApr 08, 2025
  • 2 minute read

All custom data views contain a primary table. The primary table item defines the main data source for the custom data view. You set the source data property.

Studio project hierarchy view showing a Custom View item.

A custom data view can contain only one primary table. If more than one primary table exists a validation error is generated when the project is validated.

Previous step: Add and configure a custom view

Configure View properties on the primary table

Set the source data properties of the primary table.

Studio Properties pane showing the value options for the View Name property in the View section.

Refer to the following table for the key configurable properties of Primary table.

Property

Description

Valid values

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}

Embedded Image (65% Scaling) (LIVE)

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}

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.

Note: The table source for the primary table must be an internal database. Pointing to an OLE-DB as primary source produces an error.

Studio Select Source Data dialog box showing a list of valid data source locatons to select from.

ViewName

The name of the view to use when you query for data.

Use this property to select which charts you want. In every module except Inventory, this is Standard View. In Inventory, you can choose which view to display the data, or which charts to use.

Next step: Add and configure a Secondary table (optional) or Select fields to include in custom views.

In This Topic
Related Links
TitleResults for “How to create a CRG?”Also Available in