Do you know how to sort in view by a column through code

Last updated by Tiago Araújo [SSW] almost 2 years ago.See history

You may know that it is quite easy to sort view by a column through the UI.

SortInView
Figure: Change view column sort from web UI

But when you are trying to do that via code, you may find a pretty tricky issue.

You can use some code like:

view.Query = "<OrderBy><FieldRef Name=\"Modified\" Ascending=\" FALSE \" /></OrderBy>";

Figure: Use code to change view sort

But the below code won't work:

view.Query = "<OrderBy><FieldRef Name=\"Modified\" Ascending=\" False \" /></OrderBy>";

Bad example - The Ascending attribute is case-sensitive

The full code should be some code like:

SPView view = list.DefaultView;
view.Query = "<OrderBy><FieldRef Name=\"Modified\" Ascending=\" FALSE \" /></OrderBy>";
view.Update();

Good example - The Ascending attribute is using capital charactors as it is case-sensitive

We open source. Powered by GitHub