When "Less than or Equal To," "On or Before," or "Before" is specified as a filter condition, records with blank field values are included in the filtered result

Article Number:040193

If you specify one of the following filter conditions for a certain field on the "View" screen, blank data in the field will be included in filtered records.

  • Specify a filter condition with "≦ (less than or equal to)" in the Number or Calculated field.
  • Specify a filter condition with "≦ (on or before)" or "< (before)" in the Date, Time, or Date and Time field.

If you want to exclude records from the filtered result when the specified field is blank, you also need to add "not equal to blank" condition for the filed in the filter settings.

Other than the filter settings on the "View" screen, the same rule will be applied when you configure the following.

  • "Filter" in the Settings of the Graph
  • "Initial filter setting" in the Lookup Settings
  • "Filter" in the Related records Settings
  • "Conditions to take this action" in the Settings of "Process Management"
  • "Notification Trigger" in the Settings of the "Per Record Notifications"
  • "Condition" in the Settings of "Reminder Notifications"

The following section describes examples of filer condition settings for the Number, Date and time, and Calculated fields.

Example of Filter Condition Settings

  • For the "Number" field

    • Specify [Number field] [≦ (less than or equal to)] [(any number)]
    • Add [Number field] [≠ (not equal to)] [(blank)]
    • Select "All conditions are met".

  • For the "Date and time" field

    • Specify [Date and time field] [≦ (on or before)] [specify date and time] [(any date and time)]
      Or, specify [Date and time field] [< (before)] [specify date and time] [(any date and time)]
    • Add [Date and time field] [≠ (not equal to)] [specify date and time] [(blank)]
    • Select "All conditions are met"

  • For the "Calculated" field

    • Specify [Calculated field] [≦ (less than or equal to)] [(any number)]
    • Add [Calculated field] [≠ (not equal to)] [(blank)]
    • Select "All conditions are met"