How to get item count for a List's View?

Question

I have a Sharepoint List called "Tracker" that represents customer-submitted defects. I have a View on this list that only shows the items created in the last 7 days. This view works just fine when I use Sharepoint using a web browser. I want to get the count of this View using C#.

Here's the code I've attempted, but the viewCount always comes out the same as the List's item count. What am I missing?

string webUrl = "https://mysharepointsite";
ClientContext context = new ClientContext(webUrl);

List list = context.Web.Lists.GetByTitle("Tracker");   // Should have 2107 items in it
var view = list.Views.GetByTitle("Trackers Created in Last 7 Days");  // Should have 4 items in it

context.Load(list);
context.Load(view);

context.ExecuteQuery();

int listCount = list.ItemCount;  // count = 2107

string viewQuery = view.ViewQuery;  // <Where><And><Neq><FieldRef Name="Status0" /><Value Type="Text">Closed</Value></Neq><Geq><FieldRef Name="Created" /><Value Type="DateTime"><Today OffsetDays="-7" /></Value></Geq></And></Where>

var listItemCollection = list.GetItems(new CamlQuery { ViewXml = viewQuery });            

context.Load(listItemCollection);

context.ExecuteQuery();

int viewCount = listItemCollection.Count;  // count = 2107 - this is bad, expected a value of 4

Answer 1

Using a sample CAML query from http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.client.list.getitems.aspx I noticed that their ViewXml looks different than mine. Specifically, it's wrapped in

<View> and <Query> 

tags. Modifying the XML I get back from the View:

        string viewQuery = string.Format("<View><Query>{0}</Query></View>", view.ViewQuery);  // <Where><And><Neq><FieldRef Name="Status0" /><Value Type="Text">Closed</Value></Neq><Geq><FieldRef Name="Created" /><Value Type="DateTime"><Today OffsetDays="-7" /></Value></Geq></And></Where>

        var listItemCollection = list.GetItems(new CamlQuery { ViewXml = viewQuery }); 

it now works as desired.

Answer 2

The count before the query will always return the amount in the list, if you perform the count after the query it will limit to the number that was returned in the results.