Display multi-select/checkbox field in views2

[mariagwyn]

Brief: multi-select/checkbox fields appear to display in views as a string, not as separate items.  Is there a way to fix this?

Details: I created a custom field 'academic interests', checkbox.  In views, I can call the field, but it displays like this: AgapeBioethicsBuddhist_Ethics.  What I want is this: "Agape, Bioethics, Buddhist Ethics".

Is this possible?  It appears that it is treating output as a string of text, not a list of items.
Thanks,
Maria

Update: on further investigation, this is a problem with other multiselect fields, such as "preferred_contact_method".  It just strings them all together, "123" rather than "1, 2, 3".

[Donald Lobo]

i suspect you will need to write (or fix) the handler for multi-selects in the code at: drupal/modules/views/civicrm/* to properly format the text there

we are not too familiar with the code base and cannot help u a lot there. if you do find the relevant file and fix, please do post an issue along with a patch

thanx

lobo

[junix123]

Brief: multi-select/checkbox fields appear to display in views as a string, not as separate items.  Is there a way to fix this?

Details: I created a custom field 'academic interests', checkbox.  In views, I can call the field, but it displays like this: AgapeBioethicsBuddhist_Ethics.  What I want is this: "Agape, Bioethics, Buddhist Ethics".

Is this possible?  It appears that it is treating output as a string of text, not a list of items.
Thanks,
Maria

Update: on further investigation, this is a problem with other multiselect fields, such as "preferred_contact_method".  It just strings them all together, "123" rather than "1, 2, 3".

Hi, I have the same problem in Drupal 7 and Views 3, have solve this one?
I hope you can share if it happened you solve this one.

thanks

[Upperholme]

I think we've just come up against problem using current stable D7 and Civi 4.4.6. A multiple value CiviCRM field is not being seen as such by Views, and so Views is not providing the relevant formatting options for a multi-value field.

I'm pretty sure others will have been caught by this and may have a found a solution. Any advice or pointers welcome.

[ayduns]

One option is to use the views_php module. After installing it and becoming user 1 (required to edit php sections), edit your View:

1) Add the multi-value field to the field list if not already there, but tick "Exclude from display"

2) Add a field of type Global: PHP

The values are joined with a chr(1) and have a leading and trailing chr(1) so need a little massaging to display as you want.

Leave the Value Code section blank and in the Output Code section use something like:

Code: [Select]

<?php echo str_replace( chr(1), "<br>", trim( $row->yourfield, chr(1) ) ) ?>
Replace 'yourfield' as needed by looking at the Available Variables section.  Obviously if you want commas, replace the "<br>" with ", " etc.

See https://www.drupal.org/node/1686948