Proficy Real-Time Information Portal

Proficy Real-Time Information Portal is a web-based tool for accessing, analyzing, and visualizing production information. It has sophisticated trending and reporting capabilities that take advantage of the vast archival and retrieval capabilities of Historian.

In Proficy Real Time Information Portal, parameters are used to build SQL queries that you can reuse with different values. In the place of a constant value in a SQL query, you can use a parameter, which takes a dynamic value at execution time. Parameterized SQL queries are driven by Proficy Real Time Information Portal components such as list boxes, combo boxes, or grids.

The SQL Query Builder application in Proficy Real Time Information Portal is used to define a parameterized query.

To define a parameterized query: In the Specify Selected Item Wizard or Specify Criterion Wizard, in the Parameter field, enter the name of the parameter.

The following conditions apply when you define a parameterized query:
  • Parameter names must be unique.
  • A question mark (?) is appended to the parameter name, and the parameter is enclosed in parentheses. For example, the parameter temperature becomes {temperature?}.
  • You can specify a default value for the parameter.
  • You can also select a data type for the parameter. By default, the data type is set to char. However, you can select int, date, num, or char as the type of database column.