setfilter

beasscript-logo-small

Filter on the DataWindow dw_1

comparable to the PB-command "setfilter()" und "filter()"

 

if you want to set the SQL-Filter (Where) use sqlsetfilter

Call:

setfilter=<name of the filters>=<filter-condition>

 

the following gets executed:

1. Variable "FILTER" gets a name and a filter-condition

2. Textfield "t filtererung" gets the filter-name

3. the filter-condition gets executed on the DataWindow

 

"setfilter" without parameter executes the last defined filter

 

Example:

 

setvar=filter=all pending=abgkz='N'

setfilter

 

A TAB-Change (also executed when you open the window) resets the variable "filter". If you want to set a filter for a TAB before opening use:

 

tab=filter=<TabNr>=<filter-name>=<filter-condition>

 

If you quit a TAB this command gets added to the TAB automatically.

 

Example for a filter which should be executed immediately after opening the window:

<MASTER-EVENT>

tab=filter=1=all pending=abgkz='N'

 

<RETRIEVE-EVENT>

setfilter