|
|
|
|
|
|
|
|
|
|
- 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
Selection 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: - or the order in which items are displayed in the query result: icon
 (selected by default). - or the sorting sequence in the query result: icon
 .
Note: To change the display/sort order of the various items in the query result, use the arrow buttons to the right of the item list. Modifying the values displayed in the result of the query You can display: - the year from a date item.
- the month from a date item.
- the state from an item containing a postal code.
To modify the values displayed in the result of the query: - Select a date item or an item containing a postal 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.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|