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 CiviReport (Moderator: Dave Greenberg) »
  • Bug with Relationship Status in Relationship Report
Pages: [1]

Author Topic: Bug with Relationship Status in Relationship Report  (Read 959 times)

duwease

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.2.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5
Bug with Relationship Status in Relationship Report
July 06, 2012, 12:00:10 pm
Hi,

I'm trying to run a Relationship Report with the following parameters:

Relationship Type [is equal to] Spouse
Relationship Status [is equal to] Active

However, the listing of relationships it gives includes inactive relationships (inactive by virtue of the fact that they have End Dates in the past, ergo they show up under the Inactive Relationships heading when browsing relationships for the associated contact).

I can confirm this functions the same way on the demo site.

Is this a legitimate bug, or something I'm overlooking (like, for example, are the parameters in reports considered as part of an "OR" statement instead of the implied "AND" statement)?

britebyte

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 2
  • CiviCRM version: Several 3.4+, 4.1+
  • CMS version: Drupal 6, Drupal7
  • MySQL version: Several 5.1+
  • PHP version: Several 5.2+
Re: Bug with Relationship Status in Relationship Report
July 26, 2012, 08:12:10 am
Sounds like a bug.   I took a quick look at this report and the report parameters are combined with AND. It doesn't consider the expiry date at all. I suspect that some relationships that have expired do not have the is_active field set correctly - it doesn't get updated automatically by cron for example.
I think you should file an issue for this.

jcost

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 3.4, 4.x
  • CMS version: Drupal 6.x, 7.x
  • MySQL version: various
  • PHP version: Various
Re: Bug with Relationship Status in Relationship Report
August 17, 2012, 01:58:54 pm
Does anyone know if this got logged as a bug?  I am having the same problem. 

duwease

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.2.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5
Re: Bug with Relationship Status in Relationship Report
August 20, 2012, 01:04:57 pm
I just created an issue:

http://issues.civicrm.org/jira/browse/CRM-10689
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Bug with Relationship Status in Relationship Report

This forum was archived on 2017-11-26.