Author Topic: Relationship Report: Contact Criteria not being passed correctly. (Read 2569 times)

thesamim · December 07, 2009, 04:45:55 pm

If I attempt to put in a criteria for contact B in criteria, it gets propagated to Contact A as well, giving incorrect results.

Procedure:
Click on "Reports"
Click on "Relationship Report"
Click on "Report Criteria" to expand section.
Fill Contact B criteria, eg: "Contains" "committee"
Do not select any other criteria.
Click on "Preview Report"

Following is the result:
Contact A Contains committee Contact B Contains committee status Sorry. No results found.

note that both Contact A AND Contact B now have "Contains committee".

I have tried various combination of criteria with the same result.

Sunil · December 07, 2009, 10:29:03 pm

Hi
Thanks for reporting this

Apply the following changes...

Code: [Select]

--- CRM/Report/Form/Contact/Relationship.php	(revision 25426)
+++ CRM/Report/Form/Contact/Relationship.php	(working copy)
@@ -62,8 +62,9 @@
                                        'required'   => true,
                                        ), ),
                          'filters'    =>
-                         array( 'sort_name'    =>
+                         array( 'sort_name_a'    =>
                                 array( 'title'     => ts('Contact A'),
+                                       'name'      => 'sort_name', 
                                        'operator'  => 'like',
                                        'type'      => CRM_Report_Form::OP_STRING ), ),
                          'grouping'   => 'conact_a_fields',
@@ -83,8 +84,9 @@
                                         'required'   => true,
                                        ), ),
                          'filters'    =>
-                         array( 'sort_name'=>
+                         array( 'sort_name_b'=>
                                 array( 'title'     => ts('Contact B'),
+                                       'name'      => 'sort_name',
                                        'operator'  => 'like',
                                        'type'      => CRM_Report_Form::OP_STRING ), ),
                          'grouping'   => 'conact_b_fields',

and Let's know the status.

Sunil

ken · December 08, 2009, 02:22:38 am

That patch works for me.

Thanks!

Ken

Sunil · December 08, 2009, 03:47:32 am

hi

We have filed an issue http://issues.civicrm.org/jira/browse/CRM-5513 and fixed in r25431 ( will be part of v3.0.3)
for pathc : http://fisheye2.atlassian.com/changelog/CiviCRM?cs=25431

Sunil

thesamim · December 12, 2009, 01:18:34 pm

Patch Works! Brilliant! Thanks.

I assume the fix will also automagically be in 3.1?

Dave Greenberg · December 12, 2009, 06:44:18 pm

Yes, these changes are merged periodically to the next release codebase (3.1 in this case).

CiviCRM Community Forums (archive)

News:

Author Topic: Relationship Report: Contact Criteria not being passed correctly. (Read 2569 times)

thesamim

Relationship Report: Contact Criteria not being passed correctly.

Sunil

Re: Relationship Report: Contact Criteria not being passed correctly.

ken

Re: Relationship Report: Contact Criteria not being passed correctly.

Sunil

Re: Relationship Report: Contact Criteria not being passed correctly.

thesamim

Re: Relationship Report: Contact Criteria not being passed correctly.

Dave Greenberg

Re: Relationship Report: Contact Criteria not being passed correctly.