Difference between revisions of "DBFILTER()"

Revision as of 05:22, 25 October 2011

Purpose

Function to return the filter expression

Syntax

DBFILTER([<workarea | alias>])

See Also

FILTER(), SET DELETED, SET FILTER, SET VIEW

Description

The DBFILTER() function will return, as a character string, the current filter condition or a null string if no filter is set. If the <workarea | alias> is specified, then the function will return the active filter condition for the specified alias. The command SET FILTER ON | OFF has no affect on the DBFILTER() function.

Example

use patrons
set filter to event="BALLET"
? "[" + dbfilter() + "]"
[event="BALLET"]
? type("dbfilter()")
C

Products

Recital Server, Recital