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

Details

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: