The RelationshipQuery project shows how to do relationship queries in TIBCO ActiveMatrix BusinessWorks Plug-in for Salesforce.com. Two kinds of relationship queries are defined by Salesforce.com: parent-to-children and child-to-parent.
Procedure
Start TIBCO Business Studio.
Click
File > Import.
In the
Import window, expand the
General folder and select the
Existing Studio Projects into Workspace item. Click
Next.
Click
Browse next to the
Select archive file field to locate the samples. Click
Finish.
The sample project is located in the
TIBCO_HOME\bw\palettes\salesforce\version_number\samples\RelationshipQuerySample directory.
In this project, the following four processes are created:
CreateData Process
Before running the childToParent process or the parentToChildren process, run this process to create sample sObjects with the relationship in your Salesforce.com database.
RemoveData Process
After running the childToParent process or the parentToChildren process, you can run this process to remove all the sample data from your Salesforce.com database.
Change the values in the
User Name and
Password fields in the
Connection Configuration panel of the Salesforce Connection shared resource.
Test and run the processes in the project.
Note: If some fields cannot be accessed when running the project, you might have to change the Field Accessibility configuration in the Salesforce.com database.