Customizing Query Results

The Results Form opens when a query is executed. For each query, users can customize the columns that are displayed in the results page.

In the results form displayed above, click the Customize button, and the Customize Query window (shown below) will be opened:

Each of the columns that have been defined for the query object are displayed in this form, allowing the user to customize how the columns are displayed in the results grid. As shown in the example form above, all three columns are being displayed, and all have had the columns titles modified. The subsequent query result pages will reflect the changes, but only for the current user.

To customize each of the available columns, follow through the following details for each option:

• Each row can be dragged up or down on the form to change the order. If the mouse pointer hovers over a column row, then the following tool tip is displayed: click and drag rows to change the order
• The columns can each be included or excluded from the results page. To change this option for a column, check or uncheck the checkbox in the Include column for the row of the column.
• The width of each column can also be set on this page. To manually set the width for a column, just enter the new value in the Column Width text box for that column's row. The width should be specified in pixels, i.e. 120px.

Once all of the customizations have been made, click the Save button. A Columns Updated verification message will be displayed in the top right corner of this page, and then the page can be closed by clicking the Done button.

Working through this example, the query is now customized further. After closing this window and refreshing the query results page, the page reflects the new customizations made above.

The query results page is also resizable, so it can be stretched to make the data viewable if necessary. The headers will wrap the text if necessary, but the data rows do not wrap. This may override the column width in some cases, but it does help with the readability of the results.

Did this topic help you? Email us your feedback.
Last updated: 12/16/2010 1:05:48 PM
© by Dovetail Software, Inc.