I have a kendo grid in JSTL format where I'm trying to override a filter choice for date (making the filter look for the span of an entire day like in this example. But setting a simple hardcoded filtergives no results in the kendo grid, even when there are results matching the filter:
let startOfFilterDate = new Date(2000,1,1,0,0,0)
let endOfFilterDate = new Date(2000,1,1,23,59,59)
var filter = {
logic: "and",
filters: [
{ field: "date", operator: "gte", value: startOfFilterDate },
{ field: "date", operator: "lte", value: endOfFilterDate }
]
};
e.sender.dataSource.filter(filter);
I've tried putting in various places...
1) <kendo:dataSource-change></kendo:dataSource-change
2) <kendo:grid name="search-result-grid" ... filterable="true" columnMenu="true" columnMenuInit="doFilter">
And then my "doFilter" method is pretty much the same as the given example linked to above.
If I console.log the dataSource.filter, it shows that the filters are there. But the datasource is not being updated/refreshed with the filter for whatever reason.
Hi,
Would love to know how to hide cells based on the value OR order of rows.
Here is what I have coming in:
It is a merged cell by Staff Name.
Here is what I want initially when the grid is populated:
Then… If I click on the toggle button, or the row… this would work too it would expand like this:
Trying to figure out how to filter off of the value TOTAL in the 5th column… then click a button on the 5th column (Pay Code) …and have it fully populated. The merge cell stuff I think I have got. Any idea how I could accomplish this?
Regards,
George
I've had a look and haven't found anything that answers my specific need.
I have an app that has a bill of materials and an order.
Bill of materials is a self referencing hirarchy of parts e.g.
If Assembly 1 gets added to an order then it should no longer be visible as an option in the bill of materials (nor should anything under it). Or if doodah X gets added then it and its child should no longer be visible. This is obviously a very simplified example to demonstrate the need.
Is there a way to filter out the child nodes of a treelist like this?
Given a filter control and associated grid:
Is there a way to catch the click event of the apply button?
So, I can format the cells in the resulting grid? I tried this code in the dojo with an alert ("...") and I couldn't see the alert popup on the click. I am assuming I have something really wrong here.
Hi,
Thank you for your answer to my merged rows question previously. Now I have the problem of getting the grid contents to sustain the format if I use Filter, Clear buttons in the Filter pop up or Sort. Example:
After setting the filter say for "Equals" John Smith I get:
Buuuut. I really want:
Is there a way to "bypass" or extend the function where I could use the same implementation to restructure the rows like the above.
javascript - Does Kendo Grid support cell merge or not? - Stack Overflow
I think maybe I could create a listener to catch the Filter/Clear/Sort command and capture the JavaScript array structure and implement a solution similar to the one in Stack Overflow where I loop though the array and merge the cells of the records when the text content is equal? Maybe I am imagining this?
I see there are some issues with TreeList search functionality, even on your website:
Filter Row in jQuery TreeList Widget Demo | Kendo UI for jQuery (telerik.com)
if you go on the Last Name column and switch it to "contains" and type rr, which should match a child with the value Carr, the dropdown shows no suggestions, if you actually filter it, it will filter (considering it's local filtering)
Same applies for "ends with" i tried both rr - should match Carr and ey - should match Sweeney
Am I missing something here ?
If not, is there any way to disable the suggestion dropdown ?
Thanks,
Viorel
Hi,
I want the below marked 'Contains' filter condition should be the default filter condition. Please help me how to move it to the top.
I'm trying to make changes in the kendo.filtermenu.min.js and kendo.filtermenu.min.js.map files but no luck
I'm using Kendo UI v2022.2.510 version
Hi Team,
we are using kendo UI jquery grid for displaying the data. In one of the column we have to display date time. is there a way can we filter date and time combined? with date alone we are able to filter but not with date time together. Please let us know and share the code samples/link if possible
I am looking for a help where I need to recreate the options for column filter values when the data on left hand side filter changes?
I have a drop down list country on left hand side and when ever user select the country the column(region), filter (custom filter, based on column on the grid) all the checkboxes for the custom filter should reflect the region as per the country selected.
Hello there!
I have a question regarding the use of multiple fields in one KendoGrid column.
I managed to display multiple fields in one column by using this code (data source is set dynamically using a buttongroup):
$("#users-grid").kendoGrid({
groupable: false,
filterable: { mode: "menu" },
sortable: true,
resizable: true,
pageable: true,
columns: [{
title: "OrderNumber",
field: "OrderNumber",
width: "10%",
resizable: true,
template: '#=OrderNumber#',
filterable: true
},
{
title: "Address",
field: "AddressDelivery.ZipCode",
width: "35%",
resizable: true,
template: '#=AddressDelivery.ZipCode# #=AddressDelivery.City# - #=AddressDelivery.Street# #=AddressDelivery.StreetNumber# - #=AddressDelivery.Iso3166Alpha2#'
},
{
title: "Creation Date",
field: "CreationDate",
width: "8%",
resizable: true,
template: '#=isNull(CreationDate)?\'\':kendo.toString(CreationDate, \'dd.MM.yy\')#'
},
{
title: "Complete Date",
field: "CompleteDate",
width: "8%",
resizable: true,
template: '#=isNull(CompleteDate)?\'\':kendo.toString(CompleteDate, \'dd.MM.yy\')#'
},
{
title: "Company / Last Name",
field: "AddressDelivery.Company",
width: "25%",
resizable: true,
template: '#=AddressDelivery.Company?AddressDelivery.Company:\'\'# / #=AddressDelivery. LastName#'
}]
});
However, I want to make it possible, that my Users can filter the column "Address" regarding every field that is displayed. At the moment I can only filter by AddressDelivery.ZipCode.
How would I manage that?
Best regards