SP2010 REST API from Javascript: how to set multiple fields to filter on in the URL

Question

weird but i can't figure this out or find a solution anywhere....

I want to filter on two values on a GET in REST URL from javascript. So since this is from ECMA I am just using filtering in the url...

something like:

/_vti_bin/ListData.svc/Table?$filter=Color eq 'Red'&Active eq false

doesn't work so I have tried:

/_vti_bin/ListData.svc/Table?$filter=((Color eq 'Red') and (Active eq false)
/_vti_bin/ListData.svc/Table?$filter=Color eq 'Red' and Active eq false
etc

i know that you can only use one operator at a time in a URL but I not sure how to set two or three field filters in one URL like this

appreciate any help.

Answer 1

Everywhere in this answer replace sp2010 with your site url, Table with your list name, PortalHomeDataContext with your site name (without spaces) + DataContext and RestTest.ServiceReference1 with your generated namespace.

This is tested against a SharePoint 2010 site:

http://sp2010/_vti_bin/listdata.svc/Table?$filter=(Color eq 'Red') and (Active eq false)

A very efficient way of getting the syntax (provided you know C# and LINQ) is the following:

1. Create a Console Application using visual studio
2. Add a service reference to http://sp2010/_vti_bin/listdata.svc

3. Change to console application to something like this:

   using System;
   using System.Linq;
   using RestTest.ServiceReference1;
   
   namespace RestTest
   {
     class Program
     {
       static void Main(string[] args)
       {
         var context = new PortalHomeDataContext(new Uri("http://sp2010/_vti_bin/listdata.svc"));
         context.Credentials = System.Net.CredentialCache.DefaultCredentials;
         var data = from d in context.Table
                    where d.Color == "Red" && d.Active == false
                    select d;
         foreach (var row in data)
         {
             Console.WriteLine(row.Title);
         }
       }
     }
   }
   

4. Now start Fiddler (download from http://fiddler2.com/) and run the console app. Fiddler will show the url generated by the console app.

Answer 2

I tried this using the 2013 api in SharePoint online, but I think the filter syntax should work the same...

You need to specify your boolean field as 1 or zero, like this...

https://mysite.sharepoint.com/_api/web/lists/getbytitle('defects')/items?$select=Color,Title,ID&$filter=Color eq 'Red' and Active eq 1&$top=100

Also, make sure you are using internal names, not display names.