Can you use VBO to update activities on cases?

Question

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.

Answer 1

Initially, when I built my view I was missing some relationships - thus the SQL error mentioned above. But even after adding the correct view relationships, the issue still persisted.

I got huge help from @jackrabbithanna on mattermost. He provided code for a civicrm_customs.module file that will give an "Update Activity Status" VBO action. https://gist.github.com/jackrabbithanna/34016f1e3dac7c1b44a893cc93eed6db

In notes from his chats:

this provides a separate action, not using "Modify Entity Values" action . . . that sidesteps the entity form irregularities

could do lots of complex things or whatever with API .. but this shows how to make own VBO action to people