UPDATE `ohrm_advanced_report`
SET folder_id  = (SELECT `id` FROM `ohrm_report_folder` WHERE `name` = 'Other Reports'),
    created_by = (SELECT `id` FROM `ohrm_user` WHERE `user_name` = 'ohrm_api_user'),
    is_private = '1'
WHERE unique_name IN ('v_pbi_employee_v1', 'v_pbi_leave_v1', 'v_pbi_attendance_v1', 'v_pbi_performance_v1',
                      'v_pbi_job_state_change_v1', 'v_pbi_salary_state_change_v1', 'v_pbi_vacancy_v1',
                      'v_pbi_candidate_application_v1', 'v_pbi_user_account_v1', 'v_pbi_login_v1',
                      'v_pbi_public_holidays_v1', 'v_pbi_timesheet_v1', 'v_pbi_location_v1',
                      'v_pbi_leave_entitlement_v1', 'v_pbi_goals_v1');
