PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Scope of operations
  • When to define the operations?
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
Overview
The query editor allows you to perform operations on the values of an item. The possible operations are:
  • the sum of item values.
  • the mean of item values.
  • the calculation of the minimum value for all the item values.
  • the calculation of the maximum value for all the item values.
Scope of operations
These operations are performed:
  • on all the records selected by the query.
  • on sub-sets of records (automatically grouped by the query).
For example, you want to find out:
  • the total amount of orders placed by the customers living in Seattle.
  • the order with the smallest amount.
  • the average sum spent by the customer named Darwin.
  • ...
When to define the operations?
The operations are defined when creating the query. However, you have the ability to add, modify or delete the operations performed in a query. See Operations in a query: addition and deletion for more details.
Caution: If the query result is displayed in a report, the operations to perform on the item values must be defined during report description.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment