Totara Learn Open Discussions

Completed by field in database

 
Ryan Speck
Completed by field in database
di 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
di Craig Eves (Totara Support) - Monday, 16 March 2020, 15:19
Gruppo 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