User Interface > The Browser > The Query Page

Query results window

images_queryResults

The results window displays the results of an sql query. To refresh the view click OK.

Special results formatting

Merging cells .MERGE_CELLS <start col>,<end col> The query files .SQL can contain a .MERGE_CELLS command that causes the Query Page grid to merge cells with the same values in the assigned columns range. Example: .MERGE_CELLS 1,2 SELECT T,ID,FILE_NAME FROM DOCUMENT In the above sample, the columns 1 and 2, corresponding to the fields T and ID will be merged. Autosize .RESIZE_COL_WIDTH_TO_FIT If present in a query file, it causes the Query Page grid to have the colums widths to be resized so to fit the values of the data. Example: . RESIZE_COL_WIDTH_TO_FIT SELECT T,ID,FILE_NAME FROM DOCUMENT
Here's an example of a query and the results generated: .MERGE_CELLS 1,2 .RESIZE_COL_WIDTH_TO_FIT SELECT T,ID,FILE_NAME FROM DOCUMENT ORDER BY T,ID

Merging cells

.MERGE_CELLS <start col>,<end col>
The query files .SQL can contain a .MERGE_CELLS command that causes the Query Page grid to merge cells with the same values in the assigned columns range.

Example:

.MERGE_CELLS 1,2

SELECT T,ID,FILE_NAME FROM DOCUMENT

In the above sample, the columns 1 and 2, corresponding to the fields T and ID will be merged.

Autosize

.RESIZE_COL_WIDTH_TO_FIT
If present in a query file, it causes the Query Page grid to have the colums widths to be resized so to fit the values of the data.

Example:

. RESIZE_COL_WIDTH_TO_FIT

SELECT T,ID,FILE_NAME FROM DOCUMENT

Here's an example of a query and the results generated:

.MERGE_CELLS 1,2

.RESIZE_COL_WIDTH_TO_FIT
SELECT T,ID,FILE_NAME FROM DOCUMENT
ORDER BY T,ID

images_queryMergedResult

The list allows for most common operations through shortcuts and pop-up menus.