Export Filter tab

Use this tab to create the filter condition for the export process. You can specify this information on the Export Filter tab:
Filter Condition
The condition on which the data is filtered. Possible values:
  • AND
  • OR
Note: 
  • You can use the Add Condition option to add a new row based on the selection in the Filter Condition field.
  • You can use the Add Sub Condition field to create a new set of conditions within the current condition level.
Column
The planning engine fields on which the filter condition is to be applied. This value is selected from a list of fields included in the defined mappings.
Operator
The operator used to create the filter condition. Possible values:
  • Contains
  • Does Not Contain
  • Equal To
  • Does not Equal
  • Is Null
  • Is Not Null
  • Greater Than
  • Greater Than/Equals
  • Less Than
  • Less Than/Equals
Note: 
  • The alpha fields are Contains, Does Not Contain, Equal To, Does Not Equal, Is Null, Is Not Null.
  • The Numeric and Date fields are Equal To, Does Not Equal, Is Null, Is Not Null, Greater Than, Great Than\Equals, Less Than, Less Than\Equals.
Filter Value
The value to which the filter condition must be applied.
Note: 
  • The filter value must be in the dd-mm-yyyy format, if the filtered column is a date column.
  • The value is set to Null, if not specified.
  • The application variable is replaced with the value from the system application variable if an application variable is specified when the interface service is executed.
Preview
A text overview of the defined filter condition.
Note: 

  • This tab is displayed only if Interface Direction is set to Export.

  • The required fields must be populated for each filter condition when adding a row.

  • The export filter is always combined with the Exclude Zeros from Export option, if specified on the Export Behavior tab.