[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1638) Add ability to query parent record info from child table query without joins for the Salesforce Translator

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1638.
-----------------------------------

    Resolution: Deferred


There are no plans at this time to directly support SOQL semantics.  Outer join based queries should be eligible for pushdown.  We will also at some point provide encapsulated native query support.  Those are the recommended approaches.

> Add ability to query parent record info from child table query without joins for the Salesforce Translator
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1638
>                 URL: https://issues.jboss.org/browse/TEIID-1638
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Salesforce Connector
>    Affects Versions: 7.1.1
>            Reporter: Debbie Steigner
>              Labels: eds, salesforce
>
> 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

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira