PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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
FilteredItem (Property)
In french: RubriqueFiltrée
ODBCNot available with this kind of connection
The Property Item Filtered allows to know the Item on which a filter has been set up by the HFilter function. . This property can be used on a HFSQL data file, view or query.
Versions 17 and later
iPhone/iPad This property is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for iPhone/iPad applications.
iPhone/iPad This property is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Enables the filter
HFilter(Customer, CustomerName, "D" + hValMin, "F" + hValMax, "City='Paris'")
Trace(Customer.FilteredItem)  // Indicates "CustomerName"
 
// Disables the filter
HDeactivateFilter(Customer)
Syntax
<Item> = <Element used>.FilteredItem
<Item>: Character string
  • Item onto which the filter defined by HFilter is applied,
  • Empty string ("") if no filter is enabled.
<Element used>: Character string (with or without quotes)
Name of the HFSQL data file, query or view on which the filter was defined.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment