Let me clearer
see example below. i want to sort the group by companySort DESC. I even made a companySort item by military time as i though the a/p was the problem. Then within EACH group, i needed (records in group) sorted lastChange ASC (i couldnt get that column to show in my demo)
[9/1/2017 2:00p] Home Depot
[9/1/2017 8:00a] Starbucks
[9/1/2017 2:00a] 3m
Thanks.
/Z
<%@ Page Language="C#" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
this.GridPanel1.Store.Primary.DataSource = new object[]
{
new object[] { "[9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",71.72, 0.02, 0.03, "9/1/2017T2:00" },
new object[] { "[9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m",29.01, 0.42, 1.47, "9/1/2017T8:00" },
new object[] { "[9/1/2017 2:00a] 3m", "[9/1/2017 2:00] 3m", 83.81, 0.28, 0.34, "9/1/2017T14:00" },
new object[] { "[9/1/2017 8:00a] Starbucks","[9/1/2017 8:00] Starbucks", 71.72, 0.02, 0.03, "9/1/2017T2:00" },
new object[] { "[9/1/2017 8:00a] Starbucks","[9/1/2017 8:00] Starbucks", 29.01, 0.42, 1.47, "9/1/2017T8:00" },
new object[] { "[9/1/2017 8:00a] Starbucks","[9/1/2017 8:00] Starbucks", 83.81, 0.28, 0.34, "9/1/2017T14:00" },
new object[] { "[9/1/2017 2:00p] Home Depot","[9/1/2017 14:00] Home Depot", 71.72, 0.02, 0.03, "9/1/2017T2:00" },
new object[] { "[9/1/2017 2:00p] Home Depot","[9/1/2017 14:00] Home Depot", 29.01, 0.42, 1.47, "9/1/2017T8:00" },
new object[] { "[9/1/2017 2:00p] Home Depot","[9/1/2017 14:00] Home Depot", 83.81, 0.28, 0.34, "9/1/2017T14:00" }
};
this.GridPanel1.Store.Primary.DataBind();
}
}
</script>
<!DOCTYPE html>
<html>
<head id="Head2" runat="server">
<title>GridPanel with Locking Columns - Ext.NET Examples</title>
<link href="/resources/css/examples.css" rel="stylesheet" />
<script>
var count = 0;
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 + "%");
};
var alertResponsehift = function (curSelection) {
count = 4;
curSelection.beginEdit();
curSelection.set('price', 1);
curSelection.endEdit();
};
var myRenderer = function (value, metaData, record, rowIndex, colIndex, store) {
var result = "";
for (i = 0; i < count; i++) {
result += "<div><span>TEST</span><BR/></div>";
}
return result;
};
var commandHandler = function (cmd, record, obj, grid) {
alertResponsehift(record);
};
</script>
</head>
<body>
<ext:ResourceManager ID="ResourceManager2" runat="server" />
<h1>GridPanel with Locking Columns</h1>
<p>This example shows how to achieve "freeze pane" locking functionality similar to Excel.</p>
<p>Columns may be locked or unlocked by dragging them across into the opposite side, or by using the column's header menu.</p>
<p>The "Price" column is not lockable, and may not be dragged into the locked side, or locked using the header menu.</p>
<p>It is not possible to lock <i>all</i> columns using the user interface. The unlocked side must always contain at least one column.</p>
<ext:GridPanel
ID="GridPanel1"
runat="server"
Title="Test Grid"
Width="600"
Height="350">
<Store>
<ext:Store ID="Store2" runat="server" GroupField="company">
<Model>
<ext:Model ID="Model2" runat="server">
<Fields>
<ext:ModelField Name="company" />
<ext:ModelField Name="companySort" />
<ext:ModelField Name="price" Type="Float" />
<ext:ModelField Name="change" Type="Float" />
<ext:ModelField Name="pctChange" Type="Float" />
<ext:ModelField Name="lastChange" Type="Date" />
</Fields>
</ext:Model>
</Model>
<Sorters>
<ext:DataSorter Property="companySort" Direction="DESC" />
<ext:DataGrouper Property="companySort" Direction="DESC" />
</Sorters>
</ext:Store>
</Store>
<Features>
<ext:Grouping
runat="server"
HideGroupedHeader="true"
StartCollapsed="true"
GroupHeaderTplString='{columnName}: {name} ({rows.length} Item{[values.rows.length > 1 ? "s" : ""]})' />
</Features>
<ColumnModel>
<Columns>
<ext:Column ID="Column5" runat="server" Text="Company<br>Name" DataIndex="company" Width="200" Sortable="false" />
<ext:Column ID="Column6" runat="server" Text="Price" DataIndex="price" Width="125" >
<Renderer Format="UsMoney" />
</ext:Column>
<ext:Column ID="Column7" runat="server" Text="Change" DataIndex="change" Width="125">
<Renderer Fn="change" />
</ext:Column>
<ext:Column ID="Column8" runat="server" Text="% Change" DataIndex="pctChange" Width="125">
<Renderer Fn="pctChange" />
</ext:Column>
<ext:Column DataIndex="lastChange" Text="Date" runat="server"/>
</Columns>
</ColumnModel>
</ext:GridPanel>
</body>
</html>