TRACKER_CUSTOM_DATA_AFTER_INSERT

gistfile1.txt

 DECLARE groupID INT;

    INSERT INTO TRACKER_REVIEW_AUDIT (trCTM_DataID, AUDIT_Date, EditWho_Id, WAS_Value, IS_Value, WAS_trCTM_ItemID, IS_trCTM_ItemID, WAS_Approved, IS_Approved, WAS_Expiration_Date, IS_Expiration_Date, WAS_Rej_Reason, IS_Rej_Reason, WAS_Reviewer, IS_Reviewer, WAS_Dose, IS_Dose, WAS_Administered_Date, IS_Administered_Date, IS_Test_Results, IS_Test_Result_Notes, IS_Next_Step, IS_Complete, IS_Pre, IS_Pre_Date, IS_Post, IS_Post_Date, WAS_Test_Results, WAS_Test_Result_Notes, WAS_Next_Step, WAS_Complete, WAS_Pre, WAS_Pre_Date, WAS_Post, WAS_Post_Date, IS_Record_Type, WAS_Record_Type, IS_trCTM_Status, WAS_trCTM_Status)
    VALUES (NEW.trCTM_DataID, NOW(), NEW.EDIT_Who, NULL, NEW.trCTM_Value, NULL, NEW.trCTM_ItemID, NULL, NEW.trCTM_Approved, NULL,NEW.trCTM_Expiration_Date, NULL, NEW.trCTM_Rej_Reason, NULL,  NEW.trCTM_Reviewer, NULL,  NEW.trCTM_Dose,NULL,  NEW.trCTM_Administered_Date,NEW.trCTM_Test_Results, NEW.trCTM_Test_Result_Notes, NEW.trCTM_Next_Step, NEW.trCTM_Complete, NEW.trCTM_Pre, NEW.trCTM_Pre_Date, NEW.trCTM_Post, NEW.trCTM_Post_Date, NULL,  NULL,  NULL,  NULL,  NULL,  NULL,  NULL,  NULL,  NEW.trCTM_Record_Type, NULL,  NEW.trCTM_Status, NULL );

    SELECT GRP_ID INTO groupID FROM TRACKER_CUSTOM_ITEMS WHERE trCTM_ItemID = NEW.trCTM_ItemID;
    CALL REFRESH_DASHBOARD_FOR_USER(groupID, NEW.USR_ID);
  END