CODEWITHSUNDEEP
sharepointsharepoint-2007sharepoint-2010spqueryspsitedataquery
Moon
Moon

Reputation: 35335

SPQuery calculated fields filter does not work in SharePoint 2007/2010

I have a calculated field in my list and I am trying to use filter on this field. For some reason, the following query always returns all items instead of a filtered item collection:

var spQuery = new SPQuery
    {
        Query = @"<Where><Geq><FieldRef Name='Score' /><Value Type='Calculated'>10000</Value></Geq></Where><OrderBy><FieldRef Name='Modified' Ascending='True' /></OrderBy>",
        RowLimit = 200,
        ViewFields = @"<FieldRef Name='Username' />"
    };

var spList = web.Lists["Users"];

var spListItemCollection = spList.GetItems(spQuery);

Upvotes: -1

Views: 2019

Answers (3)

Poonam
Poonam

Reputation: 11

try using

spQuery.ViewFieldsOnly = true;

Upvotes: 1

Janis Veinbergs
Janis Veinbergs

Reputation: 6988

Try removing ViewFields section (to get all columns, also those that are needed for calculation) or set SPQUery.IncludeMandatoryColumns

Upvotes: 0

Anders Rask
Anders Rask

Reputation: 862

Remove the query element from your SPQuery. See syntax here

Upvotes: 0

Related Questions