Open topic with navigation

TIBCO® Patterns 6.1.2

# Working with Mixed Record Types

Note: Working with mixed sets of child and standard records is only appropriate when dealing with child tables as only child tables can include both types of records.

You can work with a mixed set of child records and standard records in a single command. Some points to be considered are:

| • | A parent record is a standard record that has been added to a parent table. It is created and used in exactly the same way as a standard record.

| • | A child record is distinct from a standard record. APIs have special functions, methods, and constructors for creating child records. In the Java and C# APIs, there is no separate class for child records. Both use the NetricsRecord class.

| • | When referencing a child record, both portions of the key must always be given. So there are distinct methods for deleting or fetching child records to supply the two components of a key. The standard methods can only be used to delete or fetch standard records or parent records.

| • | The record add and record update operations accept either standard records or child records, and perform the appropriate action based on their record type.

| • | While loading records from a CSV file, specify the type of records in the file, standard records or child records. This is done by identifying one of the fields in the CSV file as the parent key value, in the same way as a field in the CSV file is identified as containing the record key.

The delete and fetch method for child records can operate on standard records. If the parent key value is not provided, it operates on a standard record. The record add and record update operations can accept lists containing a combination of child and standard records. While loading from a CSV file, if the field designated as the parent-record-key field is empty, a standard record is created instead of a child record.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® Patterns

Copyright © 2010-2025. Cloud Software Group, Inc. All Rights Reserved.