Expression Builder

Use to create TopLink expressions for queries.

Click Add or Add Nested to create a new expression. TopLink assigns a sequence number to each node and nested node. Select an expression node and click Remove to remove an existing node.

Select the node and use the Logical Operator drop-down list to specify the operator for the node (AND, OR, Not AND, or Not OR).

Choose the expression and enter data in each field:

First Argument

Click Edit and select the query key for the first argument. See "Adding Arguments" for more information.

Operator

Specify how TopLink should evaluate the expression. Valid operators include:

Equal
Not Equal
Equal Ignore Case
Greater Than
Greater Than Equal
Less Than
Less Than Equal
Like
Not Like
Like Ignore Case
Is Null
Not Null

Second Argument

Specify the second argument:

Literal - Click Edit and choose a literal type and value.
Query Key - Click Edit and select the query key.
Parameter - Choose a previously created parameter argument.

See "Adding Arguments" for more information.