CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Drupal views of contacts - empty results
Pages: [1]

Author Topic: Drupal views of contacts - empty results  (Read 1618 times)

kenahoo

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.15
  • MySQL version: 5.1.63
  • PHP version: 5.3.16
Drupal views of contacts - empty results
September 03, 2012, 11:31:11 am
I'm working on creating a view containing contacts in a certain CiviCRM group.  When I search within CiviCRM for contacts in this group, there are 40 or so results.  But in the view I'm creating, with the only filter criteria set to "CiviCRM Groups: Title (= This Group Title)", there are no results. 

I get no error message either.  Is there something I can investigate to see what's going wrong?

Thanks.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Drupal views of contacts - empty results
September 03, 2012, 02:00:27 pm
Is your view working normally, i.e. without filters ?

Kurund
Found this reply helpful? Support CiviCRM

kenahoo

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.15
  • MySQL version: 5.1.63
  • PHP version: 5.3.16
Re: Drupal views of contacts - empty results
September 03, 2012, 06:19:43 pm
Quote from: Kurund Jalmi on September 03, 2012, 02:00:27 pm
Is your view working normally, i.e. without filters ?

Yes, if I delete the filter criteria, then I get lots of results.

Also: my daughter wants me to use one of the smiley faces here, so here it is:  ;D

 -Ken

kenahoo

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.15
  • MySQL version: 5.1.63
  • PHP version: 5.3.16
Re: Drupal views of contacts - empty results
September 03, 2012, 06:53:19 pm
Actually, when I do add the group filter criteria back in, I get an error message when I view the view:

Quote
    Notice: Undefined index: group_type in views_handler_field->query() (line 99 of /home/singersi/public_html/sites/all/modules/views/handlers/views_handler_field.inc).

I hadn't noticed that because it doesn't show up in the preview, just when I view the actual URL path to the view.  Not sure what this means though?

 -Ken

kenahoo

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.15
  • MySQL version: 5.1.63
  • PHP version: 5.3.16
Re: Drupal views of contacts - empty results
September 05, 2012, 06:25:45 pm
Perhaps a Drupal View defined by a CiviCRM group is not supported?

fairtrademusic

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6.26
  • MySQL version: 5.0.95
  • PHP version: 5.2.17
Re: Drupal views of contacts - empty results
September 07, 2012, 01:20:37 am
I am having the same issue. Slightly different results. Namely none whatsoever. There is no data with or without sorting.

I tried to attached a screenshot of the view. It was too large. (really? only 64k?)
My settings.php looks like this

$db_url = 'mysql://actual login info@localhost/fairtrad_fairtrade';
$db_prefix = '';


$db_prefix = array(
  'civicrm_acl'                              => '`fairtrad_ftmcrm`.',
  'civicrm_acl_cache'                        => '`fairtrad_ftmcrm`.',
  'civicrm_acl_contact_cache'                => '`fairtrad_ftmcrm`.',
  'civicrm_acl_entity_role'                  => '`fairtrad_ftmcrm`.',
etc. . . .

Do I need to add the url for the Civicrm database?

kenahoo

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.15
  • MySQL version: 5.1.63
  • PHP version: 5.3.16
Re: Drupal views of contacts - empty results
September 07, 2012, 07:48:25 pm
Quote from: fairtrademusic on September 07, 2012, 01:20:37 am
I am having the same issue. Slightly different results. Namely none whatsoever. There is no data with or without sorting.

Is this only when you add filtering criteria, e.g. membership in a group?  In my case, I can get results if I eliminate the filters.

Quote from: fairtrademusic on September 07, 2012, 01:20:37 am
Do I need to add the url for the Civicrm database?

I don't think that's likely to be the culprit, at least in my case, because it's at least talking to the DB enough to see data in some cases.

 -Ken

kenahoo

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.15
  • MySQL version: 5.1.63
  • PHP version: 5.3.16
Re: Drupal views of contacts - empty results
September 09, 2012, 07:31:37 pm
So is there some way to dive into figuring out why this view isn't working properly? 

Or, alternatively, has anyone else gotten a D7 view based on a CiviCRM Group to work properly?  Right now I'm suspecting not, but perhaps not not.

russneversleeps

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Drupal 7.15
  • MySQL version: 5.5.25
  • PHP version: 5.3.13
Re: Drupal views of contacts - empty results
September 10, 2012, 06:23:14 pm
Quote from: kenahoo on September 09, 2012, 07:31:37 pm
So is there some way to dive into figuring out why this view isn't working properly? 

Or, alternatively, has anyone else gotten a D7 view based on a CiviCRM Group to work properly?  Right now I'm suspecting not, but perhaps not not.
Have you tried filtering on Group ID rather than Group Title? That seems to be working for me, although it doesn't seem to work for Smart Groups.
« Last Edit: September 10, 2012, 06:27:20 pm by russneversleeps »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Drupal views of contacts - empty results

This forum was archived on 2017-11-26.