Bug 780661 (SOA-3100)

Summary: Add ability to query parent record info from child table query without joins for the Salesforce Translator
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: dsteigne
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED DEFERRED QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0 GA   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3100
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-06-28 00:53:12 UTC Type: Feature Request
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description dsteigne 2011-06-07 17:16:21 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000007Bnqm
project_key: SOA

Salesforce.com SOQL supports selecting parent record value through reference key name.

We need to query parent record info from child table query.   For example,  if I have column parentid in Contact object which is reference key to account object,  I can do in SOQL in salesforce.com something like this.

Select c.Id, c.Name, c.AccountId, c.Account.Name
from Contact c

But if i want to do the same in EDS, I have to use Relationship Queries (join of two tables Account and Contact) which is huge impact on performance
Comment 1 Van Halbert 2011-06-14 20:26:00 UTC 
Link: Added: This issue Cloned to SOA-3110
Comment 2 Van Halbert 2011-06-28 00:53:12 UTC 
No plans at this time to add this as a feature.