filterable.operators.dateObject
The texts of the filter operators that are displayed for columns which are bound to date fields.
Omitting an operator will exclude it from the DropDownList with the available operators.
In the following example, only the Is before... and Is after... operators will be displayed in the operators DropDownList.
Example - setting the date operators
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "lastName" },
{ field: "position" },
{ field: "hireDate", format: "{0:MM/dd/yyyy}" }
],
dataSource: {
data: [
{ id: 1, parentId: null, lastName: "Jackson", position: "CEO", hireDate: new Date() },
{ id: 2, parentId: 1, lastName: "Weber", position: " VP, Engineering", hireDate: new Date() }
],
schema: {
model: {
fields: {
hireDate: { type: "date" }
}
}
}
},
filterable: {
extra: false,
operators: {
date: {
lt: "Is before...",
gt: "Is after..."
}
}
}
});
</script>filterable.operators.date.eqString(default: "Is equal to")
The text of the eq (equal to) filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
eq: "Equals"
}
}
}
});
</script>filterable.operators.date.neqString(default: "Is not equal to")
The text of the ne (not equal to) filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
neq: "Not equal to"
}
}
}
});
</script>filterable.operators.date.isnullString(default: "Is null")
The text of the isnull filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
isnull: "Is null"
}
}
}
});
</script>filterable.operators.date.isnotnullString(default: "Is not null")
The text of the isnotnull filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
isnotnull: "Is not null"
}
}
}
});
</script>filterable.operators.date.gteString(default: "Is after or equal to")
The text of the gte (greater than or equal to) filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
gte: "Is after or equal to"
}
}
}
});
</script>filterable.operators.date.gtString(default: "Is after")
The text of the gt (greater than) filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
gt: "Is after"
}
}
}
});
</script>filterable.operators.date.lteString(default: "Is before or equal to")
The text of the "lte" (less than or equal to) filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
lte: "Is before or equal to"
}
}
}
});
</script>filterable.operators.date.ltString(default: "Is before")
The text of the lt (less than) filter operator.
Example
<div id="treelist"></div>
<script>
$("#treelist").kendoTreeList({
columns: [
{ field: "Name" },
{ field: "HireDate", type: "date" }
],
dataSource: [
{ id: 1, Name: "Daryl Sweeney", HireDate: new Date("2023/1/1"), parentId: null },
{ id: 2, Name: "Guy Wooten", HireDate: new Date("2023/2/1"), parentId: 1 }
],
filterable: {
operators: {
date: {
lt: "Is before"
}
}
}
});
</script>In this article