Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 6
Registered: ‎07-12-2010

SDATA Request

[ Edited ]

Hi,

 

I'am new with ajax and sdata requests. I try to get data of all contacts of an Opportunity on client side.

In sql:

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?

 

thanks

 

Joern 

Highlighted
New Member
Posts: 6
Registered: ‎07-12-2010

Re: SDATA Request

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.

 

Joern