Working with RelationshipQuery Project

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

  1. Start TIBCO Business Studio.
  2. Click File > Import.
  3. In the Import window, expand the General folder and select the Existing Studio Projects into Workspace item. Click Next.
  4. 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.

    • ChildToParent Process

      This process shows how to do a child-to-parent relationship query and how to map the data to other activities.

      See Relationship Query for more details.

    • ParentToChildren Process

      This process shows how to do a parent-to-children relationship query and how to map the data to other activities.

      See Relationship Query for more details.

  5. Change the values in the User Name and Password fields in the Connection Configuration panel of the Salesforce Connection shared resource.
  6. 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.