PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Filter procedure
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
The Property Procedure Filter makes it possible to know and modify the Procedure to be called to filter on an row or column header during the calculation of an Pivot Table control.
Example
// Calculate the content of a pivot table
// for the stores whose group matches <"MyFilterProc">
// from January 1st, 2012
TCD_Statistics1.COL_DateInvoice.TerminalMin = "20120101".
TCD_Statistics1.COL_StoreGroup.ProcedureFilter = "MaProcFilter
PVTCalculateAll(PVT_Statistics)
 
PROCEDURE MyFilterProc(sGroupName is string)
// Ignore the stores found in the "TEST" group
IF sGroupName = "TEST" THEN RESULT False
// Take all the other ones
RESULT True
Syntax

Finding out the name of filter procedure Hide the details

<Result> = <Header to filter>.FilterProcedure
<Result>: Character string
Name of WLanguage procedure used for the filter.
<Header to filter>: Control name
Name of row or column header found in the filtered Pivot Table control.

Modifying the filter procedure associated with the header Hide the details

<Header to filter>.FilterProcedure = <New procedure>
<Header to filter>: Control name
Name of row header or column header found in the filtered pivot table.
<New procedure>: Character string
  • Name of WLanguage procedure used for the filter.
  • Empty string to disable the filter.
Remarks

Filter procedure

The filter procedure is used to choose the values that will be taken into account when calculating the Pivot Table control during the call to PVTCalculateAll and PVTCalculateUpdate.
The procedure takes in parameter the value of the key for the row header or column header for which it was defined.
This procedure must return:
  • True to accept the value
  • False to refuse it: the value will not be taken into account in the Pivot Table control.
This procedure is mainly used to speed up the calculation of the pivot table by reducing the volume to process.
Caution: Do not confuse with PVTFilter that applies to the calculated result and that gives a different vision of the result displayed.
See also
Minimum version required
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment