Use the Relational Database Query in the Designer | Operations Hub 2022 Documentation

In the main navigation menu, select APPS.

The APPS workspace appears, displaying a list of applications created in Operations Hub.

In the Name column, select the application in which you want to create a page.

The PAGES workspace appears.

Select Add new page.

The Create Page window appears.

Enter or select values as described in the following table.

Field	Description
Page name	Enter a name for the page. The name must contain at least one uppercase or lowercase letter.
Page description	Enter a description for the page.
Include in app navigation	Select this check box if you want this page to be included in the application navigation. By default, this check box is selected.

Select Create.

The page is created, and the page designer appears.

Select Page Data.

To add a Relational Database Query to the page, do the following:

The Query with sub-selected result set will be added to the page. The naming convention will be QueryName - ResultSetName.

Assigning Inputs and Outputs to components will be exactly like that of REST and Entity pages.

Note:

If a stored procedure has multiple result sets configured, the user must add each result set as an independent query in the page designer by choosing the result set.
If a stored procedure contains output parameters, then all the output parameters are treated as an additional result set.
In the case when there are multiple result sets for the query, and when the user adds them to the page, then the inputs and query execution option check boxes will be shown for the first result set, but internally they will be reflected to all the result sets for a query.
If the query has single result set, the user can add it multiple times in the page builder. But, if the same query output is changed to contain multiple result sets at a later point, then the user has to remove the second instance of the query before adding the new result set.
As of Operations Hub 1.7, The inbuilt pagination and infinite scrolling for Grid and Table components will not work with Relational Database Queries. The pagination must be handled using the input and output parameters of the stored procedure.

Select Save App.

An example is shown in the following figure.

The changes made to the page are saved.

Note: View the Page in the End app, by clicking Open App button.