FilterCondition (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FilterCondition (Property)

In french: ConditionFiltre

Not available with this kind of connection

The Property ConditionFiltre allows to know the selection condition set up by the HFilter function on a data file, a HFSQL view or a query.

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for 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 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 filter
HDeactivateFilter(Customer)

Syntax

<Selection condition> = <Element used>.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 an Ansi or Unicode character string.

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

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