ParentBO

Object and Type

Object  : FCGeneric

Type     : Property

Prototype

Public ParentBO As FCGeneric

Description

This property contains the parent generic object for this generic object. This property is used when querying multiple tables, and traversing from one to another. The object placed in this property is the parent generic. For each row in that parent generic, using the relation in the ParentRelation property,  the related rows in this object are found. For example, if we query the case table, and wish also to see the related activity logs for those cases, we would create a generic object for the activity log table, and place the case generic in the ParentBO property of the activity log generic.

Note: When you set the parent relation with ParentBO, the child object's BulkName is set to the parent's BulkName.

Example

The following example demonstrates querying the case table, and then traversing to retrieve the related contact and related site.

JavaScript:

  // Get all cases
  var boCase = FCSession.CreateGeneric();
  boCase.SimpleQuery("case");

  // Now get the related contacts
  var boContact = FCSession.CreateGeneric();
  boContact.ParentBO = boCase;
  boContact.ParentRelation = "case_reporter2contact";

  // Now get the related sites
  var boSite = FCSession.CreateGeneric();
  boSite.ParentBO = boCase;
  boSite.ParentRelation = "case_reporter2site";

  // Query the data, and display it 
  boCase.Query();

  while (boCase.EOF != true)
  {
    Response.Write ("Case: " + boCase("id_number") + "  Site/Contact: " +
                  boSite("name") + " - " + boContact("first_name") +
                  " " \+ boContact("last_name"));        
    boCase.MoveNext();
  }

Visual Basic:

  Dim boCase As FCGeneric
  Dim boSite As FCGeneric
  Dim boContact As FCGeneric

  Set boCase = fc_session.CreateGeneric
  boCase.SimpleQuery "case"

  Set boContact = fc_session.CreateGeneric
  boContact.ParentBO = boCase
  boContact.ParentRelation = "case_reporter2contact"

  Set boSite = fc_session.CreateGeneric
  boSite.ParentBO = boCase
  boSite.ParentRelation = "case_reporter2site"
  boCase.Query

  While boCase.EOF = False
    MsgBox "Case: " & boCase("id_number") & "  Site/Contact: " & _
           boSite("name") & " - " & boContact("first_name") & " " & _
           boContact("last_name")
    boCase.MoveNext
  Wend