Filter records using server-side criteria

Gets only customers that match the given OData filter expression. The filter is applied on the server. Use the service's filter syntax (e.g. Country -eq 'USA').

SELECT * FROM Customers WITH(SearchCriteria='Country eq ''USA''')