Managing selection criteria

Use selection criteria to focus on a specific set of related data by defining an SQL WHERE clause and using substitution variables with default values.

Selection criteria must conform to SQL syntax and include relational or logical operators. Logical operators and syntax vary among DBMSs. Refer to the appropriate DBMS documentation for information.

To select the desired set of data for a table, you may need a combination of AND and OR logical operators.

If a Point and Shoot list is also used, it is logically included with the other criteria with an OR logical operator.

When a relationship is traversed from child to parent, any selection criteria for the parent table are ignored.

Date criteria

A unique operator, BEFORE, allows you to select data on the basis of values in a DATE column. The syntax for this operator is:

BEFORE (nD nW nM nY)

Use the D, W, M, and Y arguments in any combination to indicate the number of days, weeks, months, or years subtracted from the date at run time. If no arguments are specified, the current date is used. Rows with a date older than the calculated date are extracted or archived. The n multiplier is an integer and can optionally be preceded by + or -.



Feedback