Query Builder

Overview
Query builder designed to query data in a single screen such as in the Client screen. For more complex queries that span multiple screens, such as including data and a client from a case, a user can use Query Builder. A user can define a SQL statement with specific input parameters from the user. Query Builder will generate the necessary screen for the user and run the query based upon the input parameters. Any standard SQL statement and keywords are allowed such as sum, count, group by, having and decode.
Using Queries from Query Builder

1. The user selects the Reports -> Query menu item.



2. The application displays the Query Builder Maintenance dialog.



3. Selects it from the List Panel and presses Edit.



4. The application displays the query.



5. The user presses the execute button. 

6. The application displays the queries Form Panel.