SET @requestStatusReportID := (SELECT id from ohrm_advanced_report WHERE unique_name = 'helpdesk_requests_by_status');
SET @requestTypesReportID := (SELECT id from ohrm_advanced_report WHERE unique_name = 'helpdesk_requests_by_type');
SET @requestPrioritiesReportID := (SELECT id from ohrm_advanced_report WHERE unique_name = 'helpdesk_requests_by_priority');
SET @requestClosureByOwnerReportID := (SELECT id from ohrm_advanced_report WHERE unique_name = 'helpdesk_request_closure_by_owner');
INSERT INTO `ohrm_report_configuration`(`report_id`, `configuration`) VALUES (@requestStatusReportID,'{"selectedDisplayFieldGroups":["1"],"selectedDisplayFields":["1","2","3","4","5","6","7","8"],"selectedFilterCriteria":{"request_status":""},"summaryConfiguration":{"summaryId":"dynamic_chart","chartType":"pie_chart","groupByFieldId":"7","aggregateFieldId":"-1","aggregateType":"count","showSummaryTable":false,"hideDetailedData":false}}'),
                                                                             (@requestTypesReportID,'{"selectedDisplayFieldGroups":["1"],"selectedDisplayFields":["1","2","3","4","5","6","7","8"],"selectedFilterCriteria":{"request_type":""},"summaryConfiguration":{"summaryId":"dynamic_chart","chartType":"pie_chart","groupByFieldId":"4","aggregateFieldId":"-1","aggregateType":"count","showSummaryTable":false,"hideDetailedData":false}}'),
                                                                             (@requestPrioritiesReportID,'{"selectedDisplayFieldGroups":["1"],"selectedDisplayFields":["1","2","3","4","5","6","7","8"],"selectedFilterCriteria":{"request_priority":""},"summaryConfiguration":{"summaryId":"dynamic_chart","chartType":"pie_chart","groupByFieldId":"8","aggregateFieldId":"-1","aggregateType":"count","showSummaryTable":false,"hideDetailedData":false}}'),
                                                                             (@requestClosureByOwnerReportID,'{"selectedDisplayFieldGroups":["1"],"selectedDisplayFields":["1","2","3","4","5","6","7","8","9"],"selectedFilterCriteria":{"resolved_date":""},"summaryConfiguration":{"summaryId":"dynamic_chart","chartType":"bar_chart","groupByFieldId":"8","aggregateFieldId":"-1","aggregateType":"count","showSummaryTable":false,"hideDetailedData":false}}');
