I'd like to be able to bulk update the status of activities (that happen to be on a case) from a view.
I can get the status to update but the problem is it loses the Case ID along the way. For example, prior to updating the activity, say it was connected to case 1234. After I run the Bulk Update to change the status of the activity, it sets the case number to 1.
Any idea how to overcome this? (I'm in Drupal 7.)
Update: When I add the CiviCRM Activities: Case ID field to the view I get an error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_activity.case_id' in 'field list'
The field should be civicrm_case_activity.case_id but I can't find in the code of CiviCRMEntity where to make that change.