PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Tips and tricks
  • Modifying the joins
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Description window of select query: Use
Overview
Let's see some operations specific to the description window of a select query:
  • modify the joins.
  • 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 joins

By default, the joins are automatically defined by the query editor.
To display and/or modify the joins that were defined automatically:
  1. Display the description window ("Query description" from the popup menu of query).
  2. Click the "Advanced" button.
  3. Display the "Joins" tab.
  4. Click the "Edit the joins" button. The description window of joins is displayed.
  5. Modify the joins if necessary.
Notes:
  • To edit the joins directly, you can also select "Edit the joins/links" from the popup menu of query.
  • You have the ability to define multiple joins between 2 files.

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" from the popup 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: .
Note: 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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment