DBFILTER()

From Recital Documentation Wiki
Revision as of 16:44, 27 November 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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