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

    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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  dsteigne Deborah Steigner
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: