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_request_v1', 'v_pbi_request_custom_field_v1');
