12

Apparently you can't filter by calculated column with SharePoint 2013 REST API? The calculated column in question returns a string.

http://site/_api/web/lists/getbytitle('TestList')/items?$filter=CalcCol eq 'blah'  -- does NOT work

http://site/_vti_bin/listdata.svc/TestList?$filter=CalcCol eq 'blah'  -- works

Am I missing something here?

  • 1
    I am surprised to find not too many questions on this problem. Thanks for posting. Let me know if you ever find a solution. – Aamir Jun 13 '16 at 14:40
1

It looks like this might be a bug in 2013.

This post suggests it also doesn't work when filtering a list in the standard view.

https://social.technet.microsoft.com/Forums/en-US/bb184556-db23-4851-9e34-3f4497a32776/filtering-by-a-calculated-column-in-sharepoint?forum=sharepointgeneral

-3

You can't do it because the calculated field is not stored anywhere, it just is rendered each time you navigate to the display form.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.