Resolved! Script to find the latest record and update a reference table value using project_status table
We want to find the latest project_status->as_on value for a project and update pm_project->u_status_date. When a user creates a new project_status report, it should in theory be the latest report (latest date) based on business process, however we ...