My case is to approve, reject or return my request, and based on that workflow should change its status. How candence can help here to save/retrieve all actions history for each workflow.
Workflow is code, so if you want to return the history of actions you would store them in a list variable and return it when queried.
As all workflow variables are persisted by the Temporal service there is no need to save them to a DB explicitly.