Click here to check out all the new features in the latest version of Operations Hub. Let Operations Hub help you centralize and digitize your industrial applications.
Important: You do not have the latest version of Operations Hub! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Operations Hub product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.
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. The steps that follow describe how this page was created.
Procedure
Add two buttons and two input boxes to the page as shown in the following figure, and make the input controls disabled.
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 show in the screenshot (+ for next, - for previous).
Select each button and set the display condition as shown in the following figures.
Select Save App.
The final page displays as shown in the first figure.
Operations Hub
