syntax:

cursor.filter

description:

A property containing a conditional expression that determines which subset of rows is retrieved by a cursor. This expression is a string containing the WHERE clause of an SQL statement describing the rows to be included. The string does not include the reserved word WHERE, however. Initially, the filter property value is set to the empty string, indicating that all of the Cursor rows are to be retrieved. Call reload after changing the filter to update the contents of the Cursor.

see:

#link <sedbc>, Cursor reload()

example:

// assume 'database' is a valid Database object

var curs = database.table("customer")

// Set cursor filter so that the Cursor

// only retrieves objects

// whose 'City' field is set to 'Berlin'

curs.filter = "City = 'Berlin'";

// Reload the cursor

err = curs.reload();