Author Topic: Views integration value/labels (again - this time with an example) (Read 3984 times)

Michael McAndrew · July 22, 2009, 12:35:36 am

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 · July 22, 2009, 08:19:43 am

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 · July 22, 2009, 08:29:34 am

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 · July 22, 2009, 10:16:32 am

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 · July 31, 2009, 07:44:32 am

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 · August 13, 2009, 10:22:23 pm

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 · August 14, 2009, 05:46:41 am

yes

lobo

mariagwyn · December 24, 2009, 09:20:10 am

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 · December 12, 2011, 11:58:37 pm

Hmmm.

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

State and Country, at the least.

CiviCRM Community Forums (archive)

News:

Author Topic: Views integration value/labels (again - this time with an example) (Read 3984 times)

Michael McAndrew

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

DanilaD

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

DanilaD

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

Michael McAndrew

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

jalama

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

petednz

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

Donald Lobo

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

mariagwyn

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

DerekL

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