Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1638

Add ability to query parent record info from child table query without joins for the Salesforce Translator

XMLWordPrintable

      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

              Unassigned Unassigned
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: