[teiid-commits] teiid SVN: r1348 - in trunk/documentation: salesforce-connector-guide/src/main/docbook/en-US/content and 1 other directory.

Author: jdoyle Date: 2009-09-14 14:35:18 -0400 (Mon, 14 Sep 2009) New Revision: 1348 Modified: trunk/documentation/pom.xml trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/appendix.xml trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/connector.xml Log: Updating SF doc for relationship queries. Modified: trunk/documentation/pom.xml =================================================================== --- trunk/documentation/pom.xml 2009-09-14 18:09:28 UTC (rev 1347) +++ trunk/documentation/pom.xml 2009-09-14 18:35:18 UTC (rev 1348) @@ -17,6 +17,7 @@ <module>connector-developer-guide</module> <module>server-extensions-guide</module> <module>quick-start-example</module> + <module>salesforce-connector-guide</module> </modules> <repositories> <repository> Modified: trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/appendix.xml =================================================================== --- trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/appendix.xml 2009-09-14 18:09:28 UTC (rev 1347) +++ trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/appendix.xml 2009-09-14 18:35:18 UTC (rev 1348) @@ -44,6 +44,9 @@ <listitem><para> CompareCriteriaOrdered </para></listitem> + <listitem><para> + OuterJoins with join criteria KEY + </para></listitem> </itemizedlist> </sect1> Modified: trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/connector.xml =================================================================== --- trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/connector.xml 2009-09-14 18:09:28 UTC (rev 1347) +++ trunk/documentation/salesforce-connector-guide/src/main/docbook/en-US/content/connector.xml 2009-09-14 18:35:18 UTC (rev 1348) @@ -221,5 +221,49 @@ </para> </sect1> + <sect1> + <title>Relationship Queries</title> + <para>Salesforce does not support joins like a relational database, + but it does have support for queries that include parent-to-child + or child-to-parent relationships between objects. These are termed + Relationship Queries. The SalesForce connector supports Relationship + Queries through Outer Join syntax. + </para> + <programlisting><![CDATA[ + SELECT Account.name, Contact.Name from Contact LEFT OUTER JOIN Account + on Contact.Accountid = Account.id + ]]> + </programlisting> + <para>This query shows the correct syntax to query a SalesForce model with + to produce a relationship query from child to parent. It resolves to the + following query to SalesForce. + </para> + <programlisting><![CDATA[ + SELECT Contact.Account.Name, Contact.Name FROM Contact + ]]> + </programlisting> + <programlisting><![CDATA[ + select Contact.Name, Account.Name from Account Left outer Join Contact + on Contact.Accountid = Account.id + ]]> + </programlisting> + <para>This query shows the correct syntax to query a SalesForce model with + to produce a relationship query from parent to child. It resolves to the + following query to SalesForce. + </para> + <programlisting><![CDATA[ + SELECT Account.Name, (SELECT Contact.Name FROM + Account.Contacts) FROM Account + ]]> + </programlisting> + <para> + See the description of the + <ulink + url="http://www.salesforce.com/us/developer/docs/api/index_Left.htm#... Queries + </ulink> + operation in the SalesForce documentation for limitations. + </para> + + </sect1> </chapter>