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>
In this article
Not finding the help you need? Improve this article