[teiid-issues] [JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5856: --------------------------------------- I don't know what you mean by references. Generally the salesforce translator will handle a single level of inner or left outer join as you expect. The one requirement is that there is a foreign key between the two tables - which should be inferred from the salesforce metadata. In this case you are performing a self-join of Product_License__c - there currently is no support for self-joins. That can certainly be captured as an issue/enhancement request. I don't follow you. Are you saying that is the SOQL teiid is generating in that example or that is what you expect to be generated? That SOQL looks correct for the SQL query - it's just a child-to-parent query https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sos... You'll have to clarify what you mean by wrong. Note that a limitation of the current salesforce translator is that only a single level of the relationship can be queried together. Introducing three entities will cause the pushdown to be split. Here again you can capture that as an enhancement request if you want. -- This message was sent by Atlassian Jira (v7.13.8#713008)