Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.2
-
Fix Version/s: 3.2.1
-
Component/s: Core CiviCRM
-
Labels:None
Description
Find Activities for some reason does NOT return activity rows for case activities when the Name (sort_name) criteria contains the name of the case client and the selected Contact Role = 'With'. This is a very common use case for this search - and the data is stored properly for case activities (e.g. there is a civicrm_activity_target row for each of these case activities with target_contact_id = client's contact ID). Not sure why the query is not returning this rows ??
To recreate -
- Create a case for 'Susan Jackson'
(you'll have a bunch of activities where Susan Jackson is the target contact) - Go to Find Activities and put 'Jackson' as Name and select 'With' for Contact Role
- none of the activities are returned
