using a 'country' field in Drupal Views displays 4 digit code

[Upperholme]

We're making a Drupal View to list, amongst other things, the selected country from a custom field linked to an activity (uses CiviCRM's country select field type).

The View displays the output as the four digit code that Civi stores rather than the country name.

I spotted this issue (https://issues.civicrm.org/jira/browse/CRM-4221), that appears to have been resolved some way back, so I'm wondering if this problem may have crept back in? Ot maybe we're just doing something wrong?

CiviCRM 4.4.6 on D7

[petednz]

i can't promise this is on 4.4.6 - i mean the site says so, but eileen has a way of having us running on sites with eileen's special sauce - but I did check a View that shows Country and in the 'country field' i see
Type of display for country field
 Display two letter country code
 Display full country name

[Upperholme]

Thanks petednz

No such level of sophistication available out of the box it seems. Wonder if you could ask Eileen where we can get the special sauce from?

From what we are seeing, Views seems generally unable to do anything other than the absolute basics with CiviCRM fields and often it is displaying stored values rather than the labels (the 4 digit code instead of country, a file url instead of the file name, etc.

Should we be using Eileen's CivicRM Entities module? I've spent a bit of time with it trying to do things with Rules - complicated - but wondering whether it adds value in terms of Views?

[petednz]

hi graham - nope certainly not entities - and i have long had these fields running fine which is why i was going down your 'regression' suggestion.

Let me grab a View and attach so we can compare like with like including the query

[Upperholme]

Thanks
I'm also wondering whether you use any other modules that might extend/enhance Views. We're just using the main Views module in this instance.

[Upperholme]

Just did some testing on a 4.5 beta site I have running locally, and that displayed all the style options you mention for a country field from a Civi contact address, but not for the custom country field.

Importantly the view displays the country name and not a code.

[petednz]

very sorry for not reading the OP. i hadn't taken in that you were talking about a custom country field - guess the handler just doesn't exist for this situation yet.