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

Salesforce translator returning duplicate records on querying with certain criteria

    Details

    • Steps to Reproduce:
      Hide
      • Create a salesforce source model containing Account and Contact tables.
      • Create a view model over this source, which contains attributes from both the tables.
      • Add the criteria Account.Id = Contact.AccountId
      • Deploy, and query using 'Select * from <view>'
      • Results returned contains each record twice.
      • This can ofcourse also been seen through the query 'Select Contact.Id, Account.Id, Contact.Name from Account, Contact where Account.Id = Contact.AccountId'
      Show
      Create a salesforce source model containing Account and Contact tables. Create a view model over this source, which contains attributes from both the tables. Add the criteria Account.Id = Contact.AccountId Deploy, and query using 'Select * from <view>' Results returned contains each record twice. This can ofcourse also been seen through the query 'Select Contact.Id, Account.Id, Contact.Name from Account, Contact where Account.Id = Contact.AccountId'

      Description

      Salesforce translator is returning each record twice when I query over a view model which is made over a Salesforce source model.

      Please find more details in the Steps to reproduce below.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                pranavk Pranav K
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: