Jan 05, 2011, 9:41 AM
DateFilter problem
Hello guys,
I have the following problem, all my other filters are working OK, but every time I try to use a DateFilter my grid gets empty.
Does anyone have a solution for this?
This is a part of my code:
I have the following problem, all my other filters are working OK, but every time I try to use a DateFilter my grid gets empty.
Does anyone have a solution for this?
This is a part of my code:
<asp:Content ID="Main" ContentPlaceHolderID="MainContent" runat="server">
<ext:Store ID="dsBatches" runat="server">
<Proxy>
<ext:HttpProxy Url="/InventoryHome/GetInventoryPartBatchesForCompany/" />
</Proxy>
<Reader>
<ext:JsonReader IDProperty="Id" Root="data" TotalProperty="total">
<Fields>
<ext:RecordField Name="Id" />
<ext:RecordField Name="BatchNo" />
<ext:RecordField Name="DateReceived" DateFormat="yyyy-MM-ddTHH:mm:ss" />
<ext:RecordField Name="ExpirationDate" DateFormat="yyyy-MM-ddTHH:mm:ss" />
<ext:RecordField Name="InventoryPart" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
<ext:Viewport ID="Viewport1" runat="server" Layout="fit">
<Items>
<ext:Panel ID="master_view" runat="server" Height="300" Border="false" Layout="Fit">
<Items>
<ext:GridPanel ID="GridPanelBatches" runat="server" Header="false" Border="false"
TrackMouseOver="true" StripeRows="true" StoreID="dsBatches" AutoScroll="true">
<ColumnModel ID="ColumnModel2" runat="server">
<Columns>
<ext:Column DataIndex="BatchNo" Header="Batch No" />
<ext:Column DataIndex="InventoryPart" Header="Inventory part" />
<ext:DateColumn DataIndex="DateReceived" Header="Date received" Align="Right" Format="yyyy-MM-dd" />
<ext:DateColumn DataIndex="ExpirationDate" Header="Expiration date" Align="Right" Format="yyyy-MM-dd" />
</Columns>
</ColumnModel>
<Plugins>
<ext:GridFilters ID="GridFilters2" runat="server" Local="true">
<Filters>
<ext:StringFilter DataIndex="BatchNo" />
<ext:DateFilter DataIndex="DateReceived" >
<DatePickerOptions runat="server" TodayText="Now" />
</ext:DateFilter>
<ext:DateFilter DataIndex="ExpirationDate" >
<DatePickerOptions runat="server" TodayText="Now" />
</ext:DateFilter>
<ext:StringFilter DataIndex="InventoryPart" />
</Filters>
</ext:GridFilters>
</Plugins>
<BottomBar>
<ext:PagingToolbar ID="PagingToolbar2" runat="server" PageSize="15" />
</BottomBar>
<LoadMask ShowMask="true" />
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel2" SingleSelect="true" runat="server">
</ext:RowSelectionModel>
</SelectionModel>
<View>
<ext:GridView ID="GridView1" runat="server" ForceFit="true" ScrollOffset="0" RowOverCls="inventory_row_over"
SelectedRowClass="inventory_row_selected" />
</View>
</ext:GridPanel>
</Items>
</ext:Panel>
</Items>
</ext:Viewport>
</asp:Content>
Thanks