Creates a child generic that is related to this generic through the specified relation
Creates a child generic that is related to this generic through the specified relation
This example shows how to traverse several generics into a hierarchy, query the parent and then iterate through the rows and display the results of the query.
// Create a dataset
ClarifyDataSet dataSet = new ClarifyDataSet(session);
// Get all cases, activity logs, and contact.
ClarifyGeneric gCase = dataSet.CreateGeneric("case");
ClarifyGeneric gAct = gCase.Traverse("case_act2act_entry");
ClarifyGeneric gContact = gCase.Traverse("case_reporter2contact");
// Now query the data
gCase.Query();
// Display return data to the console. First the case, then all
// activity logs then the one contact for the case
foreach( ClarifyDataRow caseRow in gCase )
{
Console.WriteLine("Case ID: {0}", caseRow["id_number"]);
// Show each act entry
foreach( ClarifyDataRow actRow in caseRow.RelatedRows(gAct) )
{
Console.WriteLine(" Activity: {0}", actRow["objid"]);
}
// Show each contact
foreach( ClarifyDataRow conRow in caseRow.RelatedRows(gContact) )
{
Console.WriteLine(" Contact: {0} {1}", conRow["first_name"], conRow["last_name"]);
}
}
' Create a dataset
Dim dataSet As New ClarifyDataSet(session)
' Get all cases, activity logs, and contact.
Dim gCase As ClarifyGeneric = dataSet.CreateGeneric("case")
Dim gAct As ClarifyGeneric = gCase.Traverse("case_act2act_entry")
Dim gContact As ClarifyGeneric = gCase.Traverse("case_reporter2contact")
' Now query the data
gCase.Query()
' Display return data to the console. First the case, then all
' activity logs then the one contact for the case
For Each caseRow As ClarifyDataRow In gCase
Console.WriteLine("Case ID: {0}", caseRow("id_number"))
' Show each act entry
For Each actRow As ClarifyDataRow In caseRow.RelatedRows(gAct)
Console.WriteLine(" Activity: {0}", actRow("objid"))
Next
' Show each contact
For Each conRow As ClarifyDataRow In caseRow.RelatedRows(gContact)
Console.WriteLine(" Contact: {0} {1}", conRow("first_name"), conRow("last_name"))
Next
Next