Sql statements using filter groups should be fully supported by the provider. For example the following should be translated into the correct Dynamics SDK query expression and should return the correct results:-
SELECT c.firstname, c.lastname
FROM contact c
WHERE (c.firstname = 'Chuck' AND c.lastname = 'Norris') OR (c.firstname = 'Rachel' AND c.lastname = 'Stevens')
Sql statements using filter groups should be fully supported by the provider. For example the following should be translated into the correct Dynamics SDK query expression and should return the correct results:-
SELECT c.firstname, c.lastname FROM contact c WHERE (c.firstname = 'Chuck' AND c.lastname = 'Norris') OR (c.firstname = 'Rachel' AND c.lastname = 'Stevens')