Edit this page

filterable.operators.number Object

The texts of the filter operators displayed for columns bound to number fields.

Omitting an operator will exclude it from the DropDownList with the available operators.

Example - set number operators

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        eq: "Equal to",
        neq: "Not equal to"
      }
    }
  }
});
</script>

In this example only two operators would be displayed in the DropDownList - "Equal to" and "Not equal to".

filterable.operators.number.eq String (default: "Is equal to")

The text of the "equal" filter operator.

Example - set the number "equal" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        eq: "Equal to"
      }
    }
  }
});
</script>

filterable.operators.number.neq String (default: "Is not equal to")

The text of the "not equal" filter operator.

Example - set the number "not equal" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        neq: "Not equal to"
      }
    }
  }
});
</script>

filterable.operators.number.isnull String (default: "Is null")

The text of the "isnull" filter operator.

Example - set the number "isnull" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        isnull: "Null"
      }
    }
  }
});
</script>

filterable.operators.number.isnotnull String (default: "Is not null")

The text of the "isnotnull" filter operator.

Example - set the number "isnotnull" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        isnotnull: "Not null"
      }
    }
  }
});
</script>

filterable.operators.number.gte String (default: "Is greater than or equal to")

The text of the "greater than or equal" filter operator.

Example - set the number "greater than or equal to" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        gte: "Greater than or equal to"
      }
    }
  }
});
</script>

filterable.operators.number.gt String (default: "Is greater than")

The text of the "greater than" filter operator.

Example - set the number "greater than" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        gt: "Greater than"
      }
    }
  }
});
</script>

filterable.operators.number.lte String (default: "Is less than or equal to")

The text of the "less than or equal" filter operator.

Example - set the number "less than or equal to" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        lte: "Less than or equal to"
      }
    }
  }
});
</script>

filterable.operators.number.lt String (default: "Is less than")

The text of the "less than" filter operator.

Example - set the number "less than" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: {
    data: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
    ],
    schema: {
      model: {
        fields: {
          age: { type: "number" }
        }
      }
    }
  },
  filterable: {
    operators: {
      number: {
        lt: "Less than"
      }
    }
  }
});
</script>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy