Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2025 releases!

Important Product Information
Getting Started with Operations Hub
- Getting Started with Operations Hub
  This topic describes how to work with Operations Hub using the latest (HMI powered designer) and the classic version.
- Installing Operations Hub
- Post-Installation Tasks
- Uninstalling Operations Hub
- Deploy Operations Hub Using AWS Marketplace
  You can deploy Operations Hub using a pre-configured Amazon Machine Image (AMI) available through the AWS Marketplace.
- Getting Started with Proficy Historian
- Getting Started with the Relational Database Connector
  - Get Started with Relational Database Connector
    This topic guides you through how to get started integrating the Relational Database Connector and Operations Hub.
  - Create a Query to a Relational Database
    This topic describes how to create a SQL query.
  - Use the Relational Database Query in the Designer
    This topic describes how to apply SQL queries to a page.
  - Example of Adding Relational Database Queries to a Page
- Getting Started with OPC UA
- Get Started with Proficy Plant Applications
  This topic guides you through how to get started integrating Proficy Plant Applications and Proficy Operations Hub.
- Data Binding to Widgets/Plug-ins (Classic)
  This topic describes the options you can use to bind values to widgets/plug-ins.
- HMI
- Get Started with Proficy Batch
  This topic describes how to get started with batch execution process.
- About Dataflow Editor
  A lightweight flow-based programming tool.
- Enable Windows Auto-login in an Active Directory Environment
  This topic describes how to enable Windows Auto-login in an Active Directory Environment.
- High Availability
- Use GraphQL Data in Operations Hub
  This topic covers configuring a data source and query, and binding the values to widgets, using one of two supported approaches.
User Guide

Example of Adding Relational Database Queries to a Page

About this task

In the following example, the query has two result sets. One is the result from the stored procedure and the other is from the output parameters. It also has inputs PageNumber and PageSize.

Procedure

Design a page by adding two buttons and two input boxes, and disable the input controls.
Map the input parameters of the query to the input controls.
Create two custom globals for page number and page size and provide default values as shown in the following figure.
Select each button and set the action to set the global value using a formula as shown in the figure (+ for next, - for previous).
Select each button and set the display condition as shown in the following figures.
Select Save App.

Results

The final page appears as shown here: