Hi,
I am displaying the gird data on load. When I do the advance remote filtering, the page is no getting refreshed with the filtered data. I am using the https://www.igniteui.com/grid/basic-editing example and added the filtering functionality. I can see only the loading gif.
grid.on("iggriddatabinding", function (e, args) { loadingIndicator.show(); });The other function is not getting executed.
grid.on("iggriddatabound", function (e, args) { loadingIndicator.hide(); });I tried by putting alert messages.Please helpThanksIndra
Hello Indra,
Thank you for posting into our community!
I have been looking into your question and I have tried reproducing the described behavior, however, on my side, I was not able to reproduce it.
Additionally, since I am not sure how the igGrid and the remote filtering are configured on your side, it would be highly appreciated if you could provide me with a small sample that demonstrates the described behavior.
Having a sample which I can debug on my side will be extremely helpful in investigating the root cause of this behavior and providing you with a solution as soon as possible.
Thank you for your cooperation. Looking forward to your reply.
Sincerely, Riva Ivanova Entry Level Software Developer
Hi Riva,
Than you for your response. I could able to figure out and I am good now.
Thanks
Indra
Here is the sample data:
{"RateIdentification1":"19U","RateType":"F","AssociatedRateIdentification":null,"GeneralLedgerNumber":4114,"TourGeneralLedgerNumber":4114,"CreatedDate":"2007-10-23T20:54:00","LastChangedDate":"2019-09-25T13:02:43.99"}
{"AssociatedRateIdentification":null,"GeneralLedgerNumber":4114,"TourGeneralLedgerNumber":4114,"CreatedDate":"2007-10-23T20:54:00","LastChangedDate":"2019-09-25T13:02:43.99"}
@(Html.Infragistics() .Grid(Model) .ID("rate-Grid") .Height("500px") .Width("100%") .DefaultColumnWidth("150px") .AutoGenerateColumns(false) .AutoGenerateLayouts(false) .PrimaryKey("RateIdentification") .Columns(column => { column.For(x => x.CreatedDate).HeaderText("Created Date"); column.For(x => x.AssociatedRateIdentification).HeaderText("Associated Rate Identification"); column.For(x => x.GeneralLedgerNumber).HeaderText("General Ledger Number"); column.For(x => x.TourGeneralLedgerNumber).HeaderText("Tour General Ledger Number"); column.For(x => x.LastChangedDate).HeaderText("Last Changed Date").Format("dateTime"); }) .DataSourceUrl(Url.Action("Rate")) .DataBind() .Render() )
If I remove the date, I could able to bind the data to the grid.
Thank you for your follow-up message!
I have been looking into the provided igGrid configuration and the sample data and I was able to reproduce the described behavior. The reason for receiving this error is because the PrimaryKey property is set to "RateIdentification", however, in the provided sample data the property contains 1 at the end.
@(Html.Infragistics().Grid(Model).ID("rate-Grid")....PrimaryKey("RateIdentification").Columns(column =>...
When setting the primary key to the correct property, the igGrid was displayed successfully.
Additionally, when using the format property the dataType property should be set for the respective columns, otherwise they default to “string” and the "dateTime" format will not take effect on the values.
.Columns(column => {...column.For(x => x.LastChangedDate).HeaderText("Last Changed Date").DataType("date").Format("dateTime"); })
Please let me know if you need any further assistance regarding this matter.
aha, Thank you. It is resolved now.
Thank you for your support.
Can we make the column read only while updating and allow to enter value on add new row.
I have been looking into your additional question, however, please keep in mind that according to our support policy we handle a single question per forum thread and since the initial theme is regarding binding remote filtered data, what I could suggest is creating a separate thread with your new question. This is for better consistency and history tracking.
Thank you for your cooperation.