11 Free Format Filter

The Free Form Filters contain predefined filter conditions. You cannot modify these.

1. On the Purge Filter Details screen, click on Free Format Filter tab.
   Free Format Filter screen is displayed.

   Figure 11-1 Free Format Filter

   
   

   
   Description of "Figure 11-1 Free Format Filter"

   
   
2. Final Filter expression is derived by concatenating each filters by AND operator.

For example, A Sample Filter and its constituent fields in Filter Definition

GLOBAL.APPLICATION_DATE- CSTB_CONTRACT.BOOK_DATE > 120

• • Filter Name: RETENTION
  • RHS Expression: GLOBAL.APPLICATION_DATE- CSTB_CONTRACT.BOOK_DATE
  • Operator: Greater Than
  • Default Value: 120
  • Filter Data Type: NUMBER
  • Maximum Length: 5