Filter

On the Event Action Discover File form, use this field to specify the name of the file or files being monitored for. In this case:

  • To monitor for new files, regardles of file names, you can either exclude this parameter or set it to an empty string: [FILTER("")]
  • To monitor for a specific single file, set this parameter to the name of that file.
  • You can also use wildcards (asterisks) to monitor for multiple files; for example, certain types of files (*.txt); or files with common letters, for example, win*.xml to monitor for filles that begin with the letters "win" and have an XML extension.

On the Event Action Notify or Event Action Prompt form, use this field to specify which property or properties on a form are to be filtered on when calling up a record in context, from a system message generated by a Notify or Prompt action.

In this case, this field is designed to be used in conjunction with the Filter Form field. The Filter Form field designates which form is opened, while the Filter field designates the criteria to be used in determining what is displayed when that form opens.

In all other cases, this field specifies the filter to use in restricting the data retrieval. Functionally, this is exactly the same as the Permanent Filter Expression property.

To construct the filter using an expression, click the button to the left of this field.

Note:  This parameter is not valid with custom load methods.

The contents of this field must use this syntax:

scalarExpr

where scalarExpr is or resolves to one of these:

  • For the Discover File event action only: A file name, with or without wildcards
  • In all other cases: A SQL WHERE clause without the word "WHERE" (for example, username <> 'service')

When you click OK to return to the Event Actions form, the application "wraps" this content within a FILTER( ) parameter, which yields this final syntax:

FILTER( scalarExpr )

Note:  If scalarExpr is a literal value, the system automatically encloses it in double quotation marks when returning it to the Event Actions form. If scalarExpr is an expression, the system does not enclose it in quotation marks.