Oct 21, 2010, 7:47 AM
[CLOSED] Filter and Sorting not works for GroupingSummaryColumn in Coolite Grid
Hi,
I have a grid with a Grouping Summary Column, the Sort and Filter is working for the Grouping Summary Column, please help me on this.
please find the code below
I have a grid with a Grouping Summary Column, the Sort and Filter is working for the Grouping Summary Column, please help me on this.
please find the code below
<ext:StoreID="grid_store"runat="server"IgnoreExtraFields="true"AutoLoad="true"
OnRefreshData="MyRefreshData"GroupField="SUPPLIER_NAME">
<Reader>
<ext:JsonReaderReaderID="NO">
<Fields>
<ext:RecordFieldName="SUPPLIER_NO">
</ext:RecordField>
<ext:RecordFieldName="SUPPLIER_NAME">
</ext:RecordField>
<ext:RecordFieldName="SUPPLIER_REF_NAME">
</ext:RecordField>
<ext:RecordFieldName="CITY_REF">
</ext:RecordField>
<ext:RecordFieldName="AREA">
</ext:RecordField>
<ext:RecordFieldName="USER_ID">
</ext:RecordField>
<ext:RecordFieldName="USER_NAME">
</ext:RecordField>
<ext:RecordFieldName="AREA_DESC">
</ext:RecordField>
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
<ext:GridPanelID="Grv_supplier"StoreID="grid_store"runat="server"StripeRows="true"
Border="true"TrackMouseOver="true"MaskDisabled="false"AutoScroll="true">
<ColumnModelID="ColumnModel2"runat="server">
<Columns>
<ext:ColumnSortable="true"DataIndex="SUPPLIER_NO"Width="50"Header="Supplier no"
Hidden="true">
</ext:Column>
<ext:GroupingSummaryColumnSortable="true"DataIndex="SUPPLIER_NAME"Header="Supplier name">
</ext:GroupingSummaryColumn>
<ext:ColumnSortable="true"DataIndex="SUPPLIER_REF_NAME"Header="Supplier reference"
Hidden="true">
</ext:Column>
<ext:ColumnSortable="true"DataIndex="CITY_REF"Header="City ref"Hidden="true">
</ext:Column>
<ext:ColumnSortable="true"DataIndex="AREA"Header="Area">
<Editor>
<ext:ComboBoxID="cmb_area_select"Height="40px"runat="server"StoreID="store_area"
Editable="false"DisplayField="FUNCTION_DESC"ValueField="FUNCTION_ID"TypeAhead="true"
Mode="Local"ForceSelection="true"TriggerAction="All">
</ext:ComboBox>
</Editor>
<RendererFn="userarea"/>
</ext:Column>
<ext:ColumnSortable="true"DataIndex="USER_ID"Header="User id">
<Editor>
<ext:TriggerFieldID="txt_user_id"MaxLength="10"runat="server">
<Triggers>
<ext:FieldTriggerIcon="Search"/>
</Triggers>
<Listeners>
<TriggerClickHandler="top.window_popup_open(3,'PopUpUser.aspx',650,450,user)"/>
</Listeners>
</ext:TriggerField>
</Editor>
<RendererFn="user"/>
</ext:Column>
<ext:ColumnSortable="true"DataIndex="USER_NAME"Header="User Name">
</ext:Column>
<ext:ImageCommandColumnWidth="110px">
<Commands>
<ext:ImageCommandCommandName="Add"IconCls="add">
<ToolTipText="Click to add user"/>
</ext:ImageCommand>
</Commands>
</ext:ImageCommandColumn>
<ext:ColumnSortable="true"DataIndex="AREA_DESC"Header="Area"Hidden="true">
</ext:Column>
</Columns>
<AjaxEvents>
<HiddenChangeShowWarningOnFailure="false"Timeout="120000"OnEvent="ColumnHiddenChange">
<ExtraParams>
<ext:ParameterName="index"Value="columnIndex"Mode="Raw"/>
<ext:ParameterName="hidden"Value="hidden"Mode="Raw"/>
</ExtraParams>
</HiddenChange>
</AjaxEvents>
</ColumnModel>
<Listeners>
<AfterEditFn="ValidateAfterEdit"/>
<BeforeEditFn="ValidateBeforeEdit"/>
<CommandFn="NextRow"/>
</Listeners>
<SelectionModel>
<ext:RowSelectionModelID="RowSelectionModel2"runat="server"SingleSelect="true">
<AjaxEvents>
<RowSelectOnEvent="RowSelection"ShowWarningOnFailure="false"Timeout="120000">
<ExtraParams>
<ext:ParameterName="Values"Value="Ext.encode(#{Grv_supplier}.getRowsValues(true,false,false,true))"
Mode="Raw"/>
</ExtraParams>
</RowSelect>
</AjaxEvents>
</ext:RowSelectionModel>
</SelectionModel>
<Plugins>
<ext:GridFiltersrunat="server"ID="GrdFilter1"Local="true">
<Filters>
<ext:StringFilterDataIndex="SUPPLIER_NO"/>
<ext:StringFilterDataIndex="SUPPLIER_NAME"/>
<ext:StringFilterDataIndex="SUPPLIER_REF_NAME"/>
<ext:StringFilterDataIndex="CITY_REF"/>
<ext:StringFilterDataIndex="AREA"/>
<ext:StringFilterDataIndex="USER_ID"/>
<ext:StringFilterDataIndex="USER_NAME"/>
</Filters>
</ext:GridFilters>
</Plugins>
<BottomBar>
<ext:PagingToolbarID="PagingToolBar1"runat="server"StoreID="grid_store"PageSize="20"
DisplayInfo="true">
<Listeners>
<BeforeChangeFn="Paging"/>
</Listeners>
</ext:PagingToolbar>
</BottomBar>
<View>
<ext:GroupingViewID="GroupingView1"runat="server"ForceFit="true"ShowGroupName="false"
EnableNoGroups="true"HideGroupedColumn="true"EnableGroupingMenu="false"StartCollapsed="false">
<CustomConfig>
<ext:ConfigItemName="enableCaching"Value="false"Mode="Raw"/>
</CustomConfig>
</ext:GroupingView>
</View>
<Buttons>
<ext:ButtonID="btn_edit1"runat="server"Text="Edit"AutoPostBack="false"IconCls="editicon">
<Listeners>
<ClickHandler="Coolite.AjaxMethods.BeforeEditDet();"/>
</Listeners>
</ext:Button>
<ext:ButtonID="btn_save1"runat="server"Text="Save"AutoPostBack="false"IconCls="saveicon">
<Listeners>
<ClickHandler="SaveCall();"/>
</Listeners>
</ext:Button>
<ext:ButtonID="btn_delete1"runat="server"Text="Delete"IconCls="deleteicon"AutoPostBack="false"
Disabled="true">
<Listeners>
<ClickHandler="Coolite.AjaxMethods.BeforeDelete();"/>
</Listeners>
</ext:Button>
<ext:ButtonID="btn_cancel1"runat="server"Text="Cancel"AutoPostBack="false"IconCls="cancel"
Disabled="true">
<Listeners>
<ClickHandler="Coolite.AjaxMethods.CancelDet();"/>
</Listeners>
</ext:Button>
<ext:ButtonID="btn_clear1"runat="server"Text="Clear"AutoPostBack="false"IconCls="deleteall">
<Listeners>
<ClickHandler="Coolite.AjaxMethods.ClearDet();"/>
</Listeners>
</ext:Button>
</Buttons>
<LoadMaskShowMask="true"/>
</ext:GridPanel>
Last edited by Daniil; Oct 25, 2010 at 7:39 PM.
Reason: Please use [CODE] tags, [CLOSED]