Save dashboard tab for users and restore tab on load
Description
When users use the Kotahi dashboard, they may end up primarily staying on only one of the dashboard's tabs (not implemented yet, but each current dashboard section will be changed into a tab per #1072 (closed)) according to their major roles (author/editor/reviewer). To improve their workflow, we want to save the user's last dashboard tab (before they exit the app), in the database, and use this tab when they load the dashboard back up.
Learning objectives
- React
- GraphSQL
- SQL Migrations
Todo
- Update DB value after tab is changed to
- Handle SQL migrations for updating DB value
Useful links
- Migration is the process of propagating DB schema changes to all dev db instances and production. This article is specifically referring to django but the idea is the same (https://realpython.com/django-migrations-a-primer/).