// String querySql = 'select Inspection_Report__c.Hospital__r.Parent_Management_Code__c,Inspection_Report__c.Department__r.Parent_Management_Code__c,Inspection_Report__c.Contract__r.Maintenance_Contract_No_F__c,Inspection_Report__c.Contract__r.Contract_Start_Date__c,Inspection_Report__c.Contract__r.Contract_End_Date__c, Inspection_Report__c.Contract__r.New_equipment_quantity1__c,Inspection_Report__c.spotCheckBatch__c,Inspection_Report__c.Inspection_Date__c,Inspection_Report__c.Inspection_StartTime__c,Inspection_Report__c.Inspection_EndTime__c,Inspection_Report__c.Reporter__c,Inspection_Report__c.Inspection_asset_number__c,Inspection_Report__c.Failourassetnumber__c from Inspection_Report__c where id != null ';
|