CiviCRM Community Forums (archive)

I created a multi-select custom field for contacts, and a multi-select custom field for relationship of the employee-type. The possible values are 'A', 'B' and 'C'. (just as an example)

A assigned value 'B' to a contact, and to a relationship. (In fact, I had to create a new relationship with the custom value, because CiviCRM wouldn't update an existing one, but that's another issue.)

When I use the API to retrieve the custom value 'B' of the contact

    $result = civicrm_api3('Contact', 'get', array(
    'sequential' => 1,
    'return' => "custom_7",
    'id' => 1,
    ));

I get what I expect: the selected values as an array.

    {
    "is_error":0,
    "version":3,
    "count":1,
    "id":1,
    "values":[{
    "contact_id":"1",
    "civicrm_value_mycustomset_4_id":"1",
    "custom_7":["B"],
    "id":"1"
    }]
    }
When I did the same for the relationship:

    $result = civicrm_api3('Relationship', 'get', array(
    'sequential' => 1,
    'id' => 217,
    ));
(I didn't use a result field, because that didn't work out, but that is also another issue.)

Now I get the selected values as key-value pairs:
    {
    "is_error":0,
    "version":3,
    "count":1,
    "id":217,
    "values":[{
    "id":"217",
    "contact_id_a":"202",
    "contact_id_b":"2",
    "relationship_type_id":"5",
    "is_active":"1",
    "description":"",
    "is_permission_a_b":"0",
    "is_permission_b_a":"0",
    "custom_8":{
    "B":"B"
    },
    "custom_8_1":{
    "B":"B"
    }
    }]
    }
Except when a relationship doesn't have a custom value selected for the custom field, then it is an empty array again:

    {
    "is_error":0,
    "version":3,
    "count":1,
    "id":218,
    "values":[{
    "id":"218",
    "contact_id_a":"106",
    "contact_id_b":"2",
    "relationship_type_id":"5",
    "is_active":"1",
    "description":"",
    "is_permission_a_b":"0",
    "is_permission_b_a":"0",
    "custom_8":[],
    "custom_8_2":[]
    }]
    }
So I guess the key-value result I get for custom multi-select values on relationships is a bug?

So I guess the key-value result I get for custom multi-select values on relationships is a bug?

As the wise Eileen said, "if it ain't tested, it isn't a bug".

But yes, having a different format for the same stuff based on where you call it is not logical. Custom fields are complex and we had lots of discussion about the format (eg. a custom group can have multiple record, a custom field can have multiple values...).

Can you detail the format of your custom group/field? Not sure where your case fits in the various options possible, see what is the best solution (right now as you said, it isn't, so let's call it a bug, even if we didn't break any test)

Unit tests can be found here: https://github.com/civicrm/civicrm-core/pull/5104

There are two tests in this pull request.

The first test creates a multi-select custom field for contacts. It then creates a contact with a certain value as the custom field. Then it gets the contact, and it accesses the custom value (as an array element). This test passes.

The second test does exactly the same, except that the custom field is for relationships. This test fails, because the custom value is not returned as an array of selected items, but as key-value pairs instead.