Search on empty fields / not set / blank

Uncategorized

Now it's possible to filter items by empty fields, i.e. search items with not set values.

Supported standard fields

  • AccountCode
  • Activity
  • ActualDueDate
  • ActualBudget
  • ActualStart
  • Application
  • AssignedUserGroups
  • BillType
  • CalendarDuration
  • ClosedOn
  • Description
  • DueDate
  • DueText
  • EarliestFinish
  • EarliestStart
  • FoundIn
  • Impact
  • LatestFinish
  • LatestStart
  • MitigationImpact
  • MitigationProbability
  • PerformedBy
  • PerformedFor
  • PlannedBudget
  • PlannedStart
  • Probability
  • Solution
  • SolvedIn
  • SourceDate
  • Tags

Supported custom fields

All except checkboxes.

Supported UI components

Only fields that were previously accessible for filtering in UI are supported.

  • Refine filter in list/smartlist and item overview
    • Text/number fields now have an icon (visible on hover), which will insert the empty value [ ] to the field. Could be entered manually.
    • Date/value/person pickers now have an option with empty [ ] sign.
    • Item picker have matching option in item selection dialog.
  • Smart list configuration
    • Criterias now have matching option Is Empty

API support

All fields supported in API can be filtered by empty values using EMPTY Matching in ItemFilterCriterion.