The Advanced Expression Editor window lets you define an expression for filtering purposes. Query expressions are Boolean expressions which are evaluated as being true or false.

Expression The Expression field provides the option to enter a custom expression. You can type in an expression or use the Value, Field, Function, and Operator buttons to build an expression. There is no limit to the length of the expression.

The Value button can be used to open the Value window, allowing you to enter a value to insert into the expression.

The Field button can be used to open the Select Field window, allowing you to select the desired field from the file.

The Function button can be used to open the Available Functions window, allowing you to select the desired function.

The Operator button can be used to open the Available Operators window, allowing you to select the desired operator.

The Full Expression field displays the full expression for the filter thus far. This field is updated immediately upon any change to the Expression field and displays a representation of all previous queries AND the full expression prior to saving. The Full Expression field is not editable; however, you can copy any portion of the field to the clipboard.

The OK button can be used to save the expression.

The Cancel button can be used to close the Advanced Expression Editor window without saving the expression or making changes to it.

See also: Filtering Records
  Filter Editor
  Expression Examples
  Manage Quick Clicks
  Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
  Knowledge Base Article R11493 - All About Expressions
  Knowledge Base Article R11515 - Filter Expression Examples
  Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)