Layout tab
The Layout tab contains the following information and controls:
Displays the event details that can be retrieved from the database.
To add and remove columns from this table, use the buttons to the left of the table:
•To rearrange or sort the columns for display, use the buttons to the right of the table:
Defines the criteria to use to sort the search results, including:
• Order By — specifies the columns to use to sort the data. The primary sort criteria is listed first.
• Direction — specifies whether to present the data in descending or ascending order
• Group By — indicates whether to also use the column to group the dataTo rearrange the sort criteria, use the buttons to the right of the table:
Specifies the format to use dto display the search results on the Search Results page.
When a grouping is defined, select one of the following options:
NOTE: These options are only available when a single level of grouping is defined (that is, only one column contains a Yes in the Group By column of the Sort Criteria table).To customize what is displayed for the selected search:
You can also ‘drag’ a column to the Selected Columns table.
You can also ‘drag’ a column back to the Unselected Columns table.
You can also ‘drag’ columns in this table to define the order.
7 To change the direction, ascending or descending, select a column in the Sort Criteria table, click in the Direction cell, and select either ascending (ASC) or descending (DESC) from the drop-down menu.
8 In addition, you can use the Group By column to define groupings. To group the selected search’s results, select the column to use for the grouping, click in the Group By cell and select Yes from the drop-down menu.
9 When a single level of grouping is defined (only one column contains a Yes in the Group By column of the Sort Criteria table), you can select one of the following options in the Display Results table to define the display format to use for the selected search:
▪
NOTE: You can also use Preview Changes to rerun the query to preview the changes you have made without saving them.
SQL tab
To copy the SQL query:
1
XML tab
NOTE: The XML tab is hidden by default. To display the XML tab, use the Action | Show XML Tab menu command.To copy the XML code:
Enable Alert Notifications
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center