CiviCRM Community Forums (archive)

Hello,

I'm trying to create a Drupal view to display members having signed up or renewed in a specific time period. I need to display the date the activity occurred, the contact name and address info, as well as a custom field.

There either seems to be an issue with CiviCRM Views, or I'm doing something wrong. Example:

• I create a view of type CiviCRM Activities
• add CiviCRM Activities : Activity Type (activities are visible in the preview pane)
• add filter  CiviCRM Activities : Activity Type is one of Membership Signup or Membership Renewal (preview results are correctly filtered)

So far so good, however, as soon as I add a field from any group other than CiviCRM Activities, my results become empty (no error).

I went through the same exercise using a Contributions view, and as soon as I add a field from a group other than CiviCRM Contributions, my results go blank and I get no errors.

I've searched through the forums and issue queues and haven't found any reference to this behaviour.

Help !

Hi. Please note that Views Integration is not part of core CiviCRM AFAIK. It was contributed by one individual and he is not always available to handle every support request.

That said, I am not certain what the issue is but it could well be that you have found a bug with the table relationship code for CiviCRM Views Integration. I don't have a fix for that, but I can suggest an alternative solution. You could use PHP (or even JS) code to fetch the data you need, based on the activity id, using the CiviCRM API. You could do this by customizing your view's templates.

Consider trying an end run by installing the Views Custom Field module and writing your own query.

http://drupal.org/project/views_customfield