Case Dashboard- Cases with upcoming activities and Cases with recently performed activities lists show empty
It looks like Case creates 2 SQL views

civicrm_view_case_activity_upcoming
civicrm_view_case_activity_recent

And in case dashboard/ find case results- these views are called on to provide upcoming and recent activity data.

When the database was restored from backup. These views had been emptied. And upcoming/ most recent activity data was showing as empty on the dashboards.

A colleague found some related SQL commands in
public_html/sites/all/modules/civicrm/CRM/Case/BAO/Case.php
function createCaseViewsQuery line 3057

And by running the related SQL Query was able to repopulate the views. These now automatically repopulate each time an activity is added.