FilterCondition (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FilterCondition (Property)

In french: ConditionFiltre

Not available with this kind of connection

..FilterCondition is used to find out the selection condition implemented by HFilter on a HFSQL data file, view or query.

Versions 17 and later

This property is now available for the iPhone/iPad applications.

New in version 17

This property is now available for the iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store apps mode.

New in version 18

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

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

// Enable the filter
HFilter(Customer, CustomerName, "D" + hMinVal, "F" + hMaxVal, "City='Paris'")
// Insert your process here
Trace(Customer..MaxValue)
Trace(Customer..MinValue)
Trace(Customer..FilterCondition) // Specifies "City=Paris"

// Disable the filter
HDeactivateFilter(Customer)

Syntax

<Selection condition> = <Element name>..FilterCondition

<Selection condition>: Character string

Condition specified by HFilter,
Empty string ("") if no filter is enabled or if no selection condition was specified.
This selection condition can be a character string in Ansi or Unicode format.

<Element name>: Character string (with or without quotes)

Name of the HFSQL data file, query or view on which the filter was defined.