1

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 Oct 17 '15 at 2:37
  • Where do I find that? – Flying Oct 17 '15 at 7:02
2

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 Oct 17 '15 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 Oct 17 '15 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 Oct 17 '15 at 22:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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