SPList oList = oWebsiteRoot.Lists["List_Name"]; SPQuery oQuery = new SPQuery(); oQuery.ViewFields = "<FieldRef Name='Field1'/>" + "<FieldRef Name='Field2'/>"; oQuery.Query = "<Where><Geq><FieldRef Name='Field2'/>" + "<Value Type='Number'>1000</Value></Geq></Where>"; SPListItemCollection collListItems = oList.GetItems(oQuery); foreach (SPListItem oListItem in collListItems) { ....... }
Instead of
SPQuery query = new SPQuery();
query.ViewFields = string.Format("<FieldRef Name='{0}',(FIELDS.SalesPerson.DisplayName));
I used
SPQuery query = new SPQuery(spList.Views["All Items"]);