Sort by Unbound Columns

[Jeremy Yoder]

We have a datatable with multiple keys (RoomKey, BuildingKey, etc) but no matching IDs. I'll look these up and put them into unbound column on the server-side within ItemDataBound, which I believe is my only workaround. If there is a better way, please advise.

As a result, in the grid, for each ID field's GridBoundColumn, I've removed the DataField property. But then I can't sort by my ID fields. After searching your forum, I see this is expected... but we need to sort by them. What's the workaround to enable this?

[Princy]

Hi Jeremy Yoder,

Sorting functionality for the unbound columns in the RadGrid is not possible. As those columns do not contain data items, the sorting will not work. What you can do is to manually "sort" the values  by using the header click for the unbound columns.

Thanks,
Princy

[Jeremy Yoder]

Thanks. How do I "manually sort the values by using the header click for the unbound columns"?

[Princy]

Hi Jeremy Yoder,

Please try the following code snippet:

ASPX:

<ClientSettings>
   <ClientEvents OnColumnClick="OnColumnClick" />
</ClientSettings>

JS:

<script type="text/javascript">
  function OnColumnClick(sender, args) {
    var masterTable = $find("<%= RadGrid1.ClientID %>").get_masterTableView();
    masterTable.sort(args.get_gridColumn().get_uniqueName());
    }
</script>

Thanks,
Princy

[Lina]

i get an exception because there is a call to the method which perform the select with sortExpression="Test1 ASC", but there is no such field there.

[Princy]

Hi Lina,

Its hard to identify the issue with so less information. Please provide your full code snippet to help you with your requirement.

Thanks,
Princy

[Lina]

sorry, i replied in the link you posted instead of my original which include code sample:
http://www.telerik.com/forums/how-to-add-column-which-is-updated-using-code-and-can-be-sortable#bhpSpWD1Z0igzkvD6PNB_Q