Bug 780661 (SOA-3100) - Add ability to query parent record info from child table query without joins for the Salesforce Translator
Summary: Add ability to query parent record info from child table query without joins ...
Keywords:
Status: CLOSED DEFERRED
Alias: SOA-3100
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-06-07 17:16 UTC by dsteigne
Modified: 2011-06-28 00:53 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-06-28 00:53:12 UTC
Type: Feature Request


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3100 0 Major Closed Add ability to query parent record info from child table query without joins for the Salesforce Translator 2013-01-23 12:46:06 UTC
Red Hat Issue Tracker TEIID-1638 0 Major Resolved Add ability to query parent record info from child table query without joins for the Salesforce Translator 2013-01-23 12:46:06 UTC

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.


Note You need to log in before you can comment on or make changes to this bug.