SET @folder_id = (SELECT id FROM ohrm_report_folder WHERE name = 'On/Off Boarding');
SET @report_id := (SELECT id FROM ohrm_advanced_report WHERE unique_name = 'onboarding_dashboard_summary_1');

UPDATE `ohrm_advanced_report` SET `custom_url` = '/#/onboarding/dashboard' WHERE `ohrm_advanced_report`.`unique_name` = 'onboarding_dashboard_summary_1';

UPDATE `ohrm_advanced_report` SET `folder_id`= @folder_id WHERE `id` IN (
    @report_id
    );