Number Filter Operators

Supported Operators

Jetstack's number-family filters support:

  • null
  • not_null
  • equal
  • not_equal
  • less_than
  • greater_than
  • between
  • in
  • not_in
  • in_list
  • not_in_list
  • in_subquery
  • not_in_subquery

Operator Semantics

Direct Comparison

  • equal
  • not_equal
  • less_than
  • greater_than
  • between

Use these when the value is compared directly against numeric thresholds or ranges.

Explicit Set Membership

  • in
  • not_in

Use these when the candidate set is small and local to the query.

Managed Set Membership

  • in_list
  • not_in_list

Use these when the candidate set should be managed independently through filter lists.

Subquery Membership

  • in_subquery
  • not_in_subquery

Use these when the candidate set is dynamic and should be produced by another query. These operators are especially useful in governance and complex reporting scenarios.

When To Use This Family

Use this family for:

  • IDs
  • amounts
  • sequence numbers
  • rating-like numeric values
  • any stored value where numeric ordering matters

Best Practices

  • use between for true range semantics instead of two unrelated conditions when possible
  • use subquery operators when the candidate set is owned elsewhere
  • use filter lists only when the set is stable enough to be managed as a list
Previous← FilesNextSpecial Types →