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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Enables the filter
HFilter(Customer, CustomerName, "D" + hValMin, "F" + hValMax, "City='Paris'")
Trace(Customer.FilteredItem) // Indicates "CustomerName"
// Disables the filter
<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.