...
Query Builder is very fast. Running directly on the database, it has less overhead than on the app tier.
Query Builder allows data table joins not supported in the user interface. Our monitor windows can handle most data queries, but not all. Query Builder is safe, secure, and very simple to douse. However, from time to time, users need columns that are not available on our monitor windows. We can add these columns quickly using SQL in this monitor.
There are no page size limitations on this window. Unlike other windows, having a maximum page size of 200, this window has no software limitsOther windows are typically limited to 200 rows per page.
There is no security on this window: all data is accessible. This window is only appropriate for super users or admins in the back office.
...
The Query dropdown contains a list of existing queries or groups sorted by their names. When you open the Query Builder, the system displays a list of existing queries by default. To open a query, select it from the list. The system displays the selected query description, group name, and SQL code.
...
You must have the authority to run a query. If you don't have the authority to do it, you need to ask somebody in your home office to grant you authority or to run it for you and give you the results. The authority to run queries is granted or revoked by the Security Manager, specifying the security role.
To run a query, select it and click FILTER. The system displays results in a grid.
...
All queries are organized into groups. The Group Name is a dropdown containing a list of groups sorted by their names. To
How to search for a
...
Query by
...
Group:
Double-click on the Query dropdown,
Select required a group from the groups list
Select required a query from this groups queries list
How to create a new groupGroup:
Click the “+” button on the right of Query Group dropdown
Click ADD in the Query Type window
Enter the new query type name
Click OK
Click SAVE in the Query Type window.
To delete a group How to Delete a Group:
Click the “+” button
Select a group from the list
Click DELETE in the Query Type window.
...
To assign a query to another groupHow to reassign a Query:
Open the query in the Query Builder window
Select another group from the Group Name dropdown
Click SAVE.
...
How to Create a Query
Info |
---|
Important: Adding queries are is available only in the UAT environment. |
Rw ui steps macro | |||||
---|---|---|---|---|---|
To create a new query, click the ADD button.
Enter the description and select the a group from the dropdown.
Write a new query in the Query Text field using the standard SQL (Structured Query Language) language and existing table structure.
Click SAVE.
Test a new query. Then, call the Database Administrator and ask him to evaluate it for efficiency, fix the errors if it's not written well, and then promote it into production. The clients can only run them Running a query is only available in production. |
Additional Features
Unlike the other components, the Query Builder does not support paging (predefined page size and navigation between the pages using the Next and Back buttons). Specify the Page size (number of rows) instead and click FILTER. There's no limit to the page size.
...