Rebuild Triggers (and views) should also rebuild CiviCase views
Overview
When moving CiviCRM's database to a new server and/or setting up a new database user, the views which are a part of CiviCase are not rebuilt with the new credentials after running the command civicrm-sql-rebuild-triggers
:
VIEWS
civicrm_view_case_activity_upcoming
civicrm_view_case_activity_recent
Reproduction steps
- Change the database user name and credentials
- rebuild triggers
- DB Error when accessing CiviCase components
Environment information
- CiviCRM: 5.32.2
- PHP: 7.3
- CMS: Drupal 7.x
- Database: MariaDB
Comments
Also relates to #1214 (closed)