The updated_at field of the JobApplication object was not being updated when users submitted new applications. Normally when a row is updated the updated_at column gets set to the current datetime, but if a user is updating an existing application then only the JobAnswer rows are updated, and the JobApplication row is not.
Since we want the updated_at column of the JobApplications table to reflect meaningful changes to any part of a job application, it is now manually updated whenever the application is resubmitted.
The
updated_at
field of the JobApplication object was not being updated when users submitted new applications. Normally when a row is updated theupdated_at
column gets set to the current datetime, but if a user is updating an existing application then only the JobAnswer rows are updated, and the JobApplication row is not.Since we want the
updated_at
column of the JobApplications table to reflect meaningful changes to any part of a job application, it is now manually updated whenever the application is resubmitted.