Modify default view in code to add group by

Question

As per title, is it possible (and how) to modify default view in code so that it display contents of the list grouped by one of it's columns?

I tried the following:

defaultView.Query = String.Format(@"<GroupBy collapse='true'>" +
                                          "<FieldRef Name='{0}' />" +
                                       "</GroupBy>", SPBuiltInFieldId.TaskDueDate);
defaultView.Update();

but this doesn't seem to work.

Answer 1

There are couple of ways to do it. 1. Access the view's schema XML and modify the query XML inside this. This can be achieved through SharePoint object model. 2. Use designer, generate the XSLT for the webpart and change the query appropriately.