GENERIC—EditCriteria Form

This form is used to enter advanced criteria as a WHERE clause for custom search.

Processes associated with this form

Flows:

  • OK—Apply the SQL string WHERE clause in a search.
  • Cancel—Cancel the search.
  • Clear—Clear the SQL string WHERE clause.
  • Test SQL—Test the advanced search criteria.

Form:

Criteria used to filter records returned from the search:

  • Custom form fields—List of fields associated with the searched entity.
  • Operator—Comparison used on the selected field.
  • SQL component—SQL component.
  • SQL string—SQL string containing the built WHERE clause.