To create a new table query, use the components found in the Query Def tab in the Query Definition Properties window.
Follow these steps to create a new table query.
Step
|
Action
|
|---|
|
1 |
With the Query Definitions tab displayed, click on the new button.
Result:
The Query Definition Properties screen is displayed.
|
|
2 |
In the Query Def tab, Name field enter a name, such as "sales_query (table)"
|
|
3 |
In the Category field drop down list, select a category (such as "HTTP and Streaming," "Billing," and "Smart Filter") for the selected query.
Categories help you manage the large number of pre-defined queries, as well as new queries. You may move any query to or from any category.
|
|
4 |
On the Query Type radio buttons, select Table query.
Result:
The Available Columns and Selected Columns panels appear.
|
|
5 |
In the Available Columns panel, select the data elements you want to include in this query.
Data elements are the information building-blocks in all queries, they include such items as, "user name," "cache hits," "method," and "action") The data elements are grouped by categories in subfolders under the Column List folder. To see all the available data elements, expand the Column List folder, and the individual subfolders
Note
Especially for visual/XHTML reports avoid using too many columns/data elements per query. Avoid creating a Table Query with more than 5-8 columns. All the table columns get narrower each time you add another column. |
|
6 |
To move data elements into the new query, select the element in the left-hand column and click on the arrow keys.
Result:
The data element moves into the right-hand column.
|
|
7 |
To move the position of the data element in the table, click on the element and then on the Move up and Move down keys.
Result:
The higher the element is in the column, the closer to the left that column will display in the actual displayed table query.
|
|
8 |
In the Comments field, type in the query description in that will appear above the table in the generated report. This text is optional. You can also modify or delete the default descriptions for pre-defined queries.
|
|
9 |
Click on the OK button.
Result:
The new query is added to the overall query listings in the Query Definitions page.
You can search for the new query by in the Query Definition tab by typing in the name of the query in the search field at the top of the screen and then clicking on Find.
Result:
The screen clears and the new query is listed.
|
