ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Description of queries
  • 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
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Select query description window: Use
Overview
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.
Tips and tricks

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:
  1. Select a date item or an item containing a zip code.
  2. Click the "Year, state" button.
  3. Select:
    • "Year" to display the year in the query result.
    • "State" to display the state in the query result.
  4. 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help