|
|
|
|
|
|
|
|
|
|
- Overview
- Tips and tricks
- Modifying the display order of the query elements in the list
- Modifying the values displayed in the result of the query
- Using the items coming from an existing query
Select query description window: Use
Let's see some operations specific to the description window of a select query: - modify the display order in the list of query elements.
- modify the values displayed in the query result.
- use items coming from an existing query.
Modifying the display order of the query elements in the list The query elements are listed in the central section of the description window ("Query description" in the context menu of query). The display order of the query elements in the list corresponds to: - the display order of elements in the query result:
 (option selected by default). - the sequence of sorts in the query result:
 .
Remark: To modify the display order and/or the sort order of items in the query result, use the arrow buttons found on the right of the list of elements. Modifying the values displayed in the result of the query You have the ability to display: - the year from a date item.
- the month from a date item.
- the state from an item containing a zip code.
To modify the values displayed in the result of the query: - Select a date item or an item containing a zip code.
- Click the "Year, state" button.
- Select:
- "Year" to display the year in the query result.
- "State" to display the state in the query result.
- Validate.
Using the items coming from an existing query The items that can be used in a query belong to: - a file of the analysis associated with the current application.
- a query of the current application.
The method for selecting an item belonging to an analysis file is identical to the method for selecting an item belonging to a query.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|