Views integration value/labels (again - this time with an example)

[Michael McAndrew]

Hi there,

This is a follow up to this post (http://forum.civicrm.org/index.php/topic,8411.0.html) this time with an example.

I'm not using custom data this time, but the principle is the same.

I'm using views to display various bits of data in Drupal.  One view provides a nicely themed (though depending on when you look at this, the theme might not be applied) categorised look at upcoming training. http://database.vawcvs.org/training

I've used event type as an argument in views to categorise events by type.  There is a menu on the right hand side to navigate through these types.  The problem is that the title of the page uses the event type value, not the event type label, so I get. 'Training - 6' instead of 'Training - funding'

How do I get it to display the actual label rather than the value?

Thanks a billion,
Michael

[DanilaD]

Hello, Michael.

I expect you will need to write custom handlers for those cases, as current views integration code does not support 'labels' for values stored in database. This is similar to the countries issue here: http://issues.civicrm.org/jira/browse/CRM-4221, where views show numeric IDs instead of country names.

Depending on your urgency, you have three possible ways to deal with this problem:

- dig into views integration code yourself, and write the necessary custom handlers for those cases;
- hire some professionals working with CiviCRM to do so;
- wait until someone who needs this more than you makes it.

All necessary code sits in civicrm\drupal\modules\views on your site.

Regards,
Danila

[DanilaD]

You may join forces with mariagwyn, who reports similar problems with labels-checkboxes-multiselects here:

http://forum.civicrm.org/index.php/topic,8803.0.html

I think proper solution of one of this problems will solve another.

Regards,
Danila

[Michael McAndrew]

Thanks for the info Danila,

If and when I get a mo, I'll try and dig in myself and let you know how I get on.

Michael

[jalama]

Hey Michael,

Yea it's definitely a custom handler.  Civi methods built in that deal with this for built in select field, though not for custom fields so it pull directly from the database.

Jim

[petednz]

Is it also a custom handler issue fact that for a single option checkbox (ie tick the box for YES) the data coming in through Views includes the 'CTRL+A "boxes"' (as Dave seems to refer to them here http://forum.civicrm.org/index.php/topic,9079.msg39146.html#msg39146 ie small boxes with 0s and 1s

see image below

[Donald Lobo]

yes

lobo

[mariagwyn]

Any progress on this?  I am working on a custom handler to deal with the multi-select issue (http://forum.civicrm.org/index.php/topic,8803.0.html), though it turns out that the real problem is that civi stores multi-select as a string in the data itself.  If these issues are related, any solution on this side would help immensely.  I will post the code once it is done, though I am still working on 2.2.9.

[DerekL]

Hmmm.

I'm seeing the same issue in Civi4.1alpha2.

State and Country, at the least.