How to filter w.r.t. multiple fields in oData using $filter?

javascript dynamics-crm-2011 odata
Bvrce picture Bvrce · Mar 7, 2013 · Viewed 11.2k times · Source

What is the correct way to filter w.r.t. multiple fields when applying $filter command on more than one field/value pair from JavaScript?

Answer

Konrad Viltersten picture Konrad Viltersten · Mar 7, 2013

It's very canonical.

http://192.168.75.8:5555/Konrad01/
  xrmservices/2011/OrganizationData.svc/
  LeadSet%28%29?$filter=
    Field1%20eq%20%27Value1%27%20and%20Field2%20eq%20%27Value2%27

EDIT:

More readable version.

http://Server:Port/Organization/XrmServices/2011/OrganizationData.svc/
  LeadSet()?$filter=Field1 eq 'Value1' and Field2 eq 'Value2'

Related questions

How to Execute FetchXML in CRM 2011 using a CRM 2011 webservice and JavaScript?

I want to execute FetchXML queries in a CRM 2011 environment using the CRM 2011 SOAP web services and JavaScript. I have found a number of articles like this one showing how to use the 4.0 web service that is still available in …

Read More
how to get selected value from a option set crm 4 dynamics 2011 online

This is a question related to using javascript with crm 4 2011 online I created an optionset -status: open,closed and a onchange event handler that calls the function run with the context as parameter. In js i tried the following and …

Read More
CRM 2011 - Set value of currency field with javascript

I really can't find how i can retrieve the value from a currency field and set it as a value for another currency field for another entity. My following code is not working: var entities = retrieveRecords("trainingSet?$filter=trainingId eq …

Read More