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

Salesforce translator returning duplicate records on querying with certain criteria

    XMLWordPrintable

    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.

        Attachments

          Activity

            People

            Assignee:
            rhn-engineering-shawkins Steven Hawkins
            Reporter:
            pranavk Pranav K (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: