How to Query Lookup columns of salesforce through data direc

Posted by Vinaykumar Byahatti on 31-May-2016 01:43

Hi,

I am fetching opportunity and territory data from Salesforce through data direct driver. The data can be extracted by "Select territory2.name from opportunity". Please provide inputs to implement the same query through data direct driver.

Thanks,

Vinay

DataDirect Connect - Forum

All Replies

Posted by dbradley on 07-May-2018 14:58

Hi Vinaykumar,

Are you trying to do a JOIN query between Opportunity and a custom object called "Territory2"? If so, the query you are looking for is "Select TERRITORY2.NAME from TERRTORY2 join OPPORTUNITY on <some_search_criteria>"

This thread is closed