03-16-2012 04:08 AM - edited 03-16-2012 04:10 AM
I'am new with ajax and sdata requests. I try to get data of all contacts of an Opportunity on client side.
select lastname from contact c inner join opportunity_contact oc on c.contactid = oc.contactid where oc.opportunityid = 'XXXXXXXXXXXX'
Is there someone who can help me to transform that to an correct call?
03-16-2012 06:33 AM
Ok I've got it:
select c.lastname from contact c, opportunitycontact oc where c.Id eq oc.contactid and oc.opportunityid = 'XXXXXXXXXXXX'
Problem was the casesensitivity of all entities and Attributes.