<Source>.FilterContains (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Enabling/Disabling a filter

ErrorStatusModification

FilterIncludedBetween

MigrateLinkedCompositeKey

Filter
Filtered browse
Enabling/Disabling a filter

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.FilterContains (Function)

In french: <Source>.FiltreContient

Available only with this kind of connection

Defines and enables a "Contains" filter on a data file, view or query. The "Contains" filter is used to select all the records containing a specific set of characters.

This filter is not case sensitive.

This filter does not use any index, it browses the entire data file.

Versions 18 and later

This function is now available for PHP sites.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available for PHP sites.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available for PHP sites.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

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

New in version 21

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

Example

SearchKey is string = Customer.FilterContains(Comments, "VIP")
Customer.ReadFirst(SearchKey)
WHILE NOT Customer.Out()
Trace(Customer.CustomerName, Customer.City)
Customer.ReadNext(SearchKey)
END
// Disables the filter
Customer.DeactivateFilter()

Syntax

<Result> = <Source>.FilterContains(<Item> , <Value>)

<Result>: Character string

Browse item. Corresponds to:
the name of item used to browse the data file if the filter is enabled,
an empty string ("") if the filter cannot be implemented.

<Source>: Type corresponding to the specified source

Name of HFSQL data file, view or query used.

<Item>: Character string (with or without quotes)

Name of item on which the filter will be implemented. This item can be a key item or a non-key item.

<Value>: Character string (with quotes)

Value that must be found in the record item.

Remarks

Filter

The filter is enabled as soon as <Source>.FilterContains is called.
Equivalent syntaxes:

FileName.FilterContains(ItemName, "Value")

is equivalent to:

FileName.Filter("ItemName ~]'Value'")

Filtered browse

When a filter is defined and enabled on a data file, any record read corresponds to the filter. If no other record corresponds to the filter during the browse:

<Source>.Out returns True.
the current record corresponds to the last record read with the filter.

For example:

On a filtered data file, after the function:	the current record is:

<Source>.ReadFirst	the first file record corresponding to the filter.
<Source>.ReadLast	the last file record corresponding to the filter.
<Source>.ReadNext (or <Source>.Forward)	the next record (or the next nth record) corresponding to the filter.
<Source>.ReadPrevious (or <Source>.Backward)	the previous record (or the previous nth record) corresponding to the filter.

Enabling/Disabling a filter

<Source>.DeactivateFilter is used to disable a filter.
<Source>.ActivateFilter is used to re-enable a filter.
The filter is deleted when the data file (query or view) is closed (<Source>.Close or HOpenAnalysis for example).
A single filter can exist at a given time on a data file (query or view). If <Source>.FilterContains is used several times, only the last filter will be taken into account: the previous filters will be deleted. Similarly, if several filters are used (HFilter* functions), only the last filter will be taken into account.

Component: wd260hf.dll