Since I have upgraded to the latest kendoui package this morning (2013.2.716),
one of my grids stopped binding.
The view is as follows in asp.net mvc:
@(Html.Kendo().Grid<IPMC.Web.InventoryQueryService.ProductStatistic>()
.Name("ProductStatisticsGrid")
.Columns(columns =>
{
columns.Bound(o => o.ClientProductReference).Title("Product Ref").Width(50);
columns.Bound(o => o.ProductDescription).Title("Description").Width(50);
columns.Bound(o => o.CompletedCasesCount).Title("CCC").Width(50);
columns.Bound(o => o.CompletedCasesTodayCount).Title("CCC Today").Width(50);
columns.Bound(o => o.CompletedCasesYesterdayCount).Title("CCC Yesterday").Width(50);
columns.Bound(o => o.CompletedCases1WeekCount).Title("CCC Week").Width(50);
columns.Bound(o => o.CompletedCases1MonthCount).Title("CCC Month").Width(50);
columns.Bound(o => o.PercentageOfAllCompletedCases).Title("CCC").Format("{0:P2}").Width(50);
columns.Bound(o => o.LanesAssignedToProductCount).Title("Lane Count").Width(50);
columns.Bound(o => o.CasesStoredInLanesCount).Title("Lanes Cases").Width(50);
columns.Bound(o => o.YoungestCaseEnteredInventoryTimeStampLocal).Title("Youngest Case Date").Format("{0:yyyy-MM-dd}").Width(90);
columns.Bound(o => o.OldestCaseEnteredInventoryTimeStampLocal).Title("Oldest Case Date").Format("{0:yyyy-MM-dd}").Width(90);
columns.Bound(o => o.CasesOnSequenceConveyorsFromInfeedCount).Title("SC In").Width(50);
columns.Bound(o => o.CasesOnSequenceConveyorsToOutfeedCount).Title("SC Out").Width(50);
columns.Bound(o => o.CasesSchedueledInReplenishmentsCount).Title("Replen Cases").Width(50);
columns.Bound(o => o.CasesSchedueledToCompleteAccordingToCaseSequenceCount).Title("Case Seq todo").Width(50);
})
.Groupable(t => t.Enabled(false))
.Filterable()
.Sortable()
.Pageable(p => p.Refresh(true))
.DataSource(db => db.Ajax().Read("_GetProductStatistics", "Inventory").ServerOperation(false).PageSize(100).Sort(s => s.Add("ClientProductReference")))
)
And the data received by the grid in the ajax call is :
{"Data":[{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930460)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090874477)\/","ProductId":"product-702553","ProductDescription":"4X6 CANETTE 355ml Corona","ClientProductReference":"702553","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":44,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930460)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090874477)\/","CasesSchedueledInReplenishmentsCount":53,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930655)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090875952)\/","ProductId":"product-701267","ProductDescription":"3X8 CAN Dry Cold Shot","ClientProductReference":"701267","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":2,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":43,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930655)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090875952)\/","CasesSchedueledInReplenishmentsCount":53,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":2},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930806)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090877131)\/","ProductId":"product-702707","ProductDescription":"1.18 L DRY 7.5","ClientProductReference":"702707","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":43,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930806)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090877131)\/","CasesSchedueledInReplenishmentsCount":54,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930935)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090878032)\/","ProductId":"product-700231","ProductDescription":"1.18 L Molson Dry","ClientProductReference":"700231","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":42,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930935)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090878032)\/","CasesSchedueledInReplenishmentsCount":55,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930873)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090879324)\/","ProductId":"product-703235","ProductDescription":"1.18 L Big 10.1","ClientProductReference":"703235","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":41,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930873)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090879324)\/","CasesSchedueledInReplenishmentsCount":56,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930694)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090881743)\/","ProductId":"product-704167","ProductDescription":"GROSSE CAN 710 ML Export","ClientProductReference":"704167","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":2,"CasesOnSequenceConveyorsFromInfeedCount":3,"CasesStoredInLanesCount":39,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930694)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090881743)\/","CasesSchedueledInReplenishmentsCount":56,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":2},{"YoungestCaseEnteredInventoryTimeStampLocal":null,"OldestCaseEnteredInventoryTimeStampLocal":null,"ProductId":"product-700388","ProductDescription":"Grosse 650 ML Heineken","ClientProductReference":"700388","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":0,"CasesOnSequenceConveyorsFromInfeedCount":0,"CasesStoredInLanesCount":0,"LanesAssignedToProductCount":0,"YoungestCaseEnteredInventoryTimeStampUTC":null,"OldestCaseEnteredInventoryTimeStampUTC":null,"CasesSchedueledInReplenishmentsCount":100,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1}],"Total":7,"AggregateResults":null,"Errors":null}
Any thoughts ???
one of my grids stopped binding.
The view is as follows in asp.net mvc:
@(Html.Kendo().Grid<IPMC.Web.InventoryQueryService.ProductStatistic>()
.Name("ProductStatisticsGrid")
.Columns(columns =>
{
columns.Bound(o => o.ClientProductReference).Title("Product Ref").Width(50);
columns.Bound(o => o.ProductDescription).Title("Description").Width(50);
columns.Bound(o => o.CompletedCasesCount).Title("CCC").Width(50);
columns.Bound(o => o.CompletedCasesTodayCount).Title("CCC Today").Width(50);
columns.Bound(o => o.CompletedCasesYesterdayCount).Title("CCC Yesterday").Width(50);
columns.Bound(o => o.CompletedCases1WeekCount).Title("CCC Week").Width(50);
columns.Bound(o => o.CompletedCases1MonthCount).Title("CCC Month").Width(50);
columns.Bound(o => o.PercentageOfAllCompletedCases).Title("CCC").Format("{0:P2}").Width(50);
columns.Bound(o => o.LanesAssignedToProductCount).Title("Lane Count").Width(50);
columns.Bound(o => o.CasesStoredInLanesCount).Title("Lanes Cases").Width(50);
columns.Bound(o => o.YoungestCaseEnteredInventoryTimeStampLocal).Title("Youngest Case Date").Format("{0:yyyy-MM-dd}").Width(90);
columns.Bound(o => o.OldestCaseEnteredInventoryTimeStampLocal).Title("Oldest Case Date").Format("{0:yyyy-MM-dd}").Width(90);
columns.Bound(o => o.CasesOnSequenceConveyorsFromInfeedCount).Title("SC In").Width(50);
columns.Bound(o => o.CasesOnSequenceConveyorsToOutfeedCount).Title("SC Out").Width(50);
columns.Bound(o => o.CasesSchedueledInReplenishmentsCount).Title("Replen Cases").Width(50);
columns.Bound(o => o.CasesSchedueledToCompleteAccordingToCaseSequenceCount).Title("Case Seq todo").Width(50);
})
.Groupable(t => t.Enabled(false))
.Filterable()
.Sortable()
.Pageable(p => p.Refresh(true))
.DataSource(db => db.Ajax().Read("_GetProductStatistics", "Inventory").ServerOperation(false).PageSize(100).Sort(s => s.Add("ClientProductReference")))
)
And the data received by the grid in the ajax call is :
{"Data":[{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930460)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090874477)\/","ProductId":"product-702553","ProductDescription":"4X6 CANETTE 355ml Corona","ClientProductReference":"702553","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":44,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930460)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090874477)\/","CasesSchedueledInReplenishmentsCount":53,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930655)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090875952)\/","ProductId":"product-701267","ProductDescription":"3X8 CAN Dry Cold Shot","ClientProductReference":"701267","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":2,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":43,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930655)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090875952)\/","CasesSchedueledInReplenishmentsCount":53,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":2},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930806)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090877131)\/","ProductId":"product-702707","ProductDescription":"1.18 L DRY 7.5","ClientProductReference":"702707","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":43,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930806)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090877131)\/","CasesSchedueledInReplenishmentsCount":54,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930935)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090878032)\/","ProductId":"product-700231","ProductDescription":"1.18 L Molson Dry","ClientProductReference":"700231","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":42,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930935)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090878032)\/","CasesSchedueledInReplenishmentsCount":55,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930873)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090879324)\/","ProductId":"product-703235","ProductDescription":"1.18 L Big 10.1","ClientProductReference":"703235","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":1,"CasesOnSequenceConveyorsFromInfeedCount":2,"CasesStoredInLanesCount":41,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930873)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090879324)\/","CasesSchedueledInReplenishmentsCount":56,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1},{"YoungestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090930694)\/","OldestCaseEnteredInventoryTimeStampLocal":"\/Date(1374090881743)\/","ProductId":"product-704167","ProductDescription":"GROSSE CAN 710 ML Export","ClientProductReference":"704167","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":2,"CasesOnSequenceConveyorsFromInfeedCount":3,"CasesStoredInLanesCount":39,"LanesAssignedToProductCount":3,"YoungestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090930694)\/","OldestCaseEnteredInventoryTimeStampUTC":"\/Date(1374090881743)\/","CasesSchedueledInReplenishmentsCount":56,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":2},{"YoungestCaseEnteredInventoryTimeStampLocal":null,"OldestCaseEnteredInventoryTimeStampLocal":null,"ProductId":"product-700388","ProductDescription":"Grosse 650 ML Heineken","ClientProductReference":"700388","CompletedCasesCount":0,"CompletedCasesTodayCount":0,"CompletedCasesYesterdayCount":0,"CompletedCases1WeekCount":0,"CompletedCases1MonthCount":0,"PercentageOfAllCompletedCases":NaN,"CasesOnSequenceConveyorsToOutfeedCount":0,"CasesOnSequenceConveyorsFromInfeedCount":0,"CasesStoredInLanesCount":0,"LanesAssignedToProductCount":0,"YoungestCaseEnteredInventoryTimeStampUTC":null,"OldestCaseEnteredInventoryTimeStampUTC":null,"CasesSchedueledInReplenishmentsCount":100,"CasesSchedueledToCompleteAccordingToCaseSequenceCount":1}],"Total":7,"AggregateResults":null,"Errors":null}
Any thoughts ???