The Query Builder utilizes the eCASE Drag and Drop feature, allowing users to build a query using the Query Build area and the Query-Related Objects menu. The Query-Related Objects menu features available tables and views, query properties, and parameters, which can be directly applied to the Query Build area, where they can be configured and manipulated.
Joining Table/Views
Follow the steps below to join multiple tables or views:
1. Select the data source
2. Click Add Query. The Data Source Wizard appears.
3. Click Run Query Builder. The Query Builder window appears.
4. Drag a table/view into the workspace from the Available Tables menu or Parameters menu.
5. Drag a second table/view into the workspace from the Available Tables menu.
6. Click a column in one table/view and drag it to the corresponding item in the second table/view. This creates the Join Condition. Repeat this step for each Join Condition required.
NOTE: Queries must be joined on a column that is the same between both tables
.png?sv=2022-11-02&spr=https&st=2026-03-10T17%3A27%3A39Z&se=2026-03-10T17%3A38%3A39Z&sr=c&sp=r&sig=jl%2F8BNceznbCggkiThUgi7KSrNQ39%2BiDBulXKmyckp4%3D)
7. Click the checkbox associated with each column you wish to display in the report.
8. Click OK to return to the Data Source Wizard. The generated query can be seen from the SQL string text area.
Preview Results
After a query is finalized in the Query Builder the result can be previewed by clicking Preview Results. The Data Preview window appears, providing only raw data in table format.
NOTE: The full report can be previewed by clicking Preview in the toolbar.
