Mar 31, 2014, 12:17 PM
[CLOSED] Datecolumn sort issue
Hi guys,
I'm having a grid with a datecolumn populated with an yyyymmdd integer column. I can fix it by setting the dateformat in the modelfield. Filtering is working as expected, but sorting isn't. It sorts on days ...instead of date. Can you help me ?
I'm having a grid with a datecolumn populated with an yyyymmdd integer column. I can fix it by setting the dateformat in the modelfield. Filtering is working as expected, but sorting isn't. It sorts on days ...instead of date. Can you help me ?
<%@ Page Language="C#" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
this.Store1.DataSource = this.Data;
this.Store1.DataBind();
}
}
private object[] Data
{
get
{
return new object[]
{
new object[] { "3m Co", 71.72, 0.02, 0.03, 20121211 },
new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, 20131205 },
new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, 20140101 },
new object[] { "American Express Company", 52.55, 0.01, 0.02, 20111122 },
};
}
}
</script>
<!DOCTYPE html>
<html>
<head runat="server">
<title>Simple Array Grid - Ext.NET Examples</title>
<link href="/resources/css/examples.css" rel="stylesheet" />
<style>
.x-grid-row-over .x-grid-cell-inner {
font-weight : bold;
}
</style>
<script>
var template = '<span style="color:{0};">{1}</span>';
var change = function (value) {
return Ext.String.format(template, (value > 0) ? "green" : "red", value);
};
var pctChange = function (value) {
return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
};
</script>
</head>
<body>
<ext:ResourceManager runat="server" />
<h1>Simple Array Grid</h1>
<ext:GridPanel
ID="GridPanel1"
runat="server"
Title="Array Grid"
Width="600"
Height="350">
<Store>
<ext:Store ID="Store1" runat="server">
<Model>
<ext:Model runat="server">
<Fields>
<ext:ModelField Name="company" />
<ext:ModelField Name="price" Type="Float" />
<ext:ModelField Name="change" Type="Float" />
<ext:ModelField Name="pctChange" Type="Float" />
<ext:ModelField Name="lastChange" Type="Date" DateFormat="yyyymmdd" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel>
<Columns>
<ext:Column runat="server" Text="Company" DataIndex="company" Flex="1" />
<ext:Column runat="server" Text="Price" DataIndex="price">
<Renderer Format="UsMoney" />
</ext:Column>
<ext:Column runat="server" Text="Change" DataIndex="change">
<Renderer Fn="change" />
</ext:Column>
<ext:Column runat="server" Text="Change" DataIndex="pctChange">
<Renderer Fn="pctChange" />
</ext:Column>
<ext:DateColumn runat="server" Text="Last Updated" DataIndex="lastChange" format="dd-mm-yyyy"/>
</Columns>
</ColumnModel>
<Features>
<ext:GridFilters runat="server" ID="gfIssues" Local="true">
<Filters>
<ext:DateFilter DataIndex="lastChange" AutoDataBind="true">
<DatePickerOptions runat="server" Format="dd-mm-yyyy" TodayText="Now" />
</ext:DateFilter>
</Filters>
</ext:GridFilters>
</Features>
<SelectionModel>
<ext:RowSelectionModel runat="server" />
</SelectionModel>
<BottomBar>
<ext:Toolbar runat="server">
<Items>
<ext:Button runat="server" Text="Print" Icon="Printer" Handler="this.up('grid').print();" />
</Items>
</ext:Toolbar>
</BottomBar>
</ext:GridPanel>
</body>
</html>
Last edited by Daniil; Apr 03, 2014 at 2:47 AM.
Reason: [CLOSED]