3.1.1.1.51.2.1 GetAllAssociationsForValueId

The GetAllAssociationsForValueId procedure can be used to retrieve all the custom field values that are associated with a specified custom field value.

The following input parameter is used in this procedure.

Param_valueId: This is a signed integer that represents a custom field value Id for which the associations are retrieved.

The following is the output parameter from this procedure.

Result_customFieldValueAssociations: This is a collection of tuples of signed 64-bit integer in which each entry represents the association mapping for a specific set of custom field values.

The following processing steps are performed:

  1. Retrieve all the rows in ADM_MultiValueCustomFieldValueAssociationTable with CustomFieldValueId1 or CustomFieldValueId2 equal to Param_valueId.

  2. If no such rows are found, initialize Result_customFieldValueAssociations as NULL and return from the procedure.

  3. Initialize Result_customFieldValueAssociations as a collection of tuples.

  4. Initialize an instance of tuple and assign CustomFieldValueId1 and CustomFieldValueId2 to it. Add this instance to Result_customFieldValueAssociations collection.

  5. Return Result_customFieldValueAssociations as the output of the procedure.