I have problems with showing aggregated custom data.

Some frequently asked questions:

  • Yes, I have succesfully set up Drupal Views connected to the CiviCRM database, with the php.settings.file

  • Yes, I have checked the Access custom data permissions.

  • Yes, I have also set up the View with User field, and not the CiviCRM Contact field.

I am trying to achieve this:

The count of new contacts recruited this year (date of recruitment is a custom field).

What I get:

I only get the count of new contact recruited this year that is ALSO a Drupal user. But I cannot find any criteria or field that should refine the result like that.

Do anyone have a tip for what to check for?

  • Can you inspect the sql query generated by views to get a clue?
    – Coleman
    Commented Oct 17, 2015 at 2:37
  • Where do I find that?
    – Flying
    Commented Oct 17, 2015 at 7:02

1 Answer 1


If your View is based on 'users' then your result makes sense.

If your View is based on 'civi contact' then your result doesn't make sense unless you are using contextual filter, relationship or filter to specify 'user'.

  • If I base it on 'Civi contact' I do not get the custom fields
    – Flying
    Commented Oct 17, 2015 at 7:03
  • Are the custom fields used for contacts? If they are then they should be available. We do stuff like this with Views pretty regularly.
    – pmoz
    Commented Oct 17, 2015 at 21:55
  • In some cases you also need to clear Drupal caches to get new civi custom fields to show in Views
    – petednz - fuzion
    Commented Oct 17, 2015 at 22:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.