Loading...

XML

Word

Printable

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'

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.