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:
Retrieve all the rows in ADM_MultiValueCustomFieldValueAssociationTable with CustomFieldValueId1 or CustomFieldValueId2 equal to Param_valueId.
If no such rows are found, initialize Result_customFieldValueAssociations as NULL and return from the procedure.
Initialize Result_customFieldValueAssociations as a collection of tuples.
Initialize an instance of tuple and assign CustomFieldValueId1 and CustomFieldValueId2 to it. Add this instance to Result_customFieldValueAssociations collection.
Return Result_customFieldValueAssociations as the output of the procedure.