Totara Learn Open Discussions

Completed by field in database

 
Ryan Speck
Completed by field in database
par Ryan Speck, Monday 16 March 2020, 06:30
 

We are looking to modify the completed by date for our appraisal process. We are not able to do it on the form in Totara since the appraisals have already started. What table and field in the database do I need to update to accomplish this?

Craig Eves
Re: Completed by field in database
par Craig Eves (Totara Support), Monday 16 March 2020, 15:19
Groupe Totara

Hi Ryan

There is a database schema available on the puiblic developer docs Looking at the appraisal user assignment table  there is a timecompleted field included that is not linked to another table.

We do not recommend you to update values in the database - if you do decide to update the database then you need to back up the database and fully test this out as there may be some programming logic that depends on the time completed field value.

Regards