Hi, all!
I have an RagGrid. To this grid, I use AllowFilteringByColumn = true and GroupByExpression to some columns. But, I need this RadGrid result, expand after a filter, without grouping.
How make the RadGrid result expand after filter?
My code.
I have an RagGrid. To this grid, I use AllowFilteringByColumn = true and GroupByExpression to some columns. But, I need this RadGrid result, expand after a filter, without grouping.
How make the RadGrid result expand after filter?
My code.
<script type=
"text/javascript"
>
(
function
() {
var
demo = window.demo = {},
autoCompleteBox,
masterTableView;
demo.GridCreated =
function
(sender, args) {
masterTableView = sender.get_masterTableView();
}
demo.AutoCompleteLoaded =
function
(sender, args) {
autoCompleteBox = sender;
}
demo.EntryAdded =
function
(sender, args) {
filterGrid();
}
demo.EntryRemoved =
function
(sender, args) {
filterGrid();
}
function
filterGrid() {
if
(!masterTableView || !autoCompleteBox)
return
;
var
entries = autoCompleteBox.get_entries();
if
(entries.get_count() === 0) {
masterTableView.expandAllGroups();
return
;
}
masterTableView.collapseAllGroups();
$telerik.$(masterTableView.get_element()).find(
"td"
).filter(
function
() {
for
(
var
i = 0; i < entries.get_count(); i++)
if
($(
this
).text().indexOf(entries.getEntry(i).get_text()) !== -1)
return
true
;
return
false
;
}).closest(
".rgRow, .rgAltRow"
).each(
function
() {
masterTableView.expandGroup(
this
);
});
}
window.pageLoad =
function
() {
$(masterTableView.get_element())
.find(
".rgGroupHeader td"
)
.not(
".rgGroupCol"
)
.css(
"cursor"
,
"pointer"
)
.click(
function
() {
masterTableView.toggleGroup($(
this
).closest(
"tr"
)[0]);
});
}
})();
</script>
<
Telerik:RadGrid
ID
=
"RadGrid1"
DataSourceID
=
"SqlDataSource1"
runat
=
"server"
AllowSorting
=
"True"
AllowPaging
=
"False"
AutoGenerateColumns
=
"False"
GridLines
=
"None"
AllowFilteringByColumn
=
"true"
>
<
GroupingSettings
CaseSensitive
=
"false"
></
GroupingSettings
>
<
MasterTableView
Width
=
"100%"
GroupLoadMode
=
"Client"
TableLayout
=
"Fixed"
GroupsDefaultExpanded
=
"false"
>
<
GroupByExpressions
>
<
Telerik:GridGroupByExpression
>
<
SelectFields
>
<
Telerik:GridGroupByField
FieldAlias
=
"REGION"
FieldName
=
"REGION"
HeaderText
=
"REGION"
>
</
Telerik:GridGroupByField
>
</
SelectFields
>
<
GroupByFields
>
<
Telerik:GridGroupByField
FieldName
=
"REGION"
></
Telerik:GridGroupByField
>
</
GroupByFields
>
</
Telerik:GridGroupByExpression
>
<
Telerik:GridGroupByExpression
>
<
SelectFields
>
<
Telerik:GridGroupByField
FieldAlias
=
"LOCATIONNAME"
FieldName
=
"LOCATIONNAME"
HeaderText
=
"LOCATION NAME"
>
</
Telerik:GridGroupByField
>
</
SelectFields
>
<
GroupByFields
>
<
Telerik:GridGroupByField
FieldAlias
=
"LOCATIONNAME"
FieldName
=
"LOCATIONNAME"
></
Telerik:GridGroupByField
>
</
GroupByFields
>
</
Telerik:GridGroupByExpression
>
</
GroupByExpressions
>
<
Columns
>
<
Telerik:GridBoundColumn
DataField
=
"LOCATIONNAME"
FilterControlAltText
=
"Filter LOCATIONNAME column"
UniqueName
=
"LOCATIONNAME"
>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
Telerik:GridBoundColumn
>
<
Telerik:GridHyperLinkColumn
DataNavigateUrlFields
=
"IDSERVER"
DataNavigateUrlFormatString
=
"PathFolders.aspx?idServer={0}"
DataTextField
=
"SERVERNAME"
FilterControlAltText
=
"Filter SERVERNAME column"
UniqueName
=
"column"
>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
Telerik:GridHyperLinkColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
ReorderColumnsOnClient
=
"True"
AllowDragToGroup
=
"True"
AllowColumnsReorder
=
"True"
>
<
ClientEvents
OnGridCreated
=
"demo.GridCreated"
/>
</
ClientSettings
>
<
GroupingSettings
ShowUnGroupButton
=
"true"
></
GroupingSettings
>
</
Telerik:RadGrid
>