TRACKER_CUSTOM_DATA_AFTER_UPDATE

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(), COALESCE(NEW.EDIT_Who, OLD.EDIT_Who), OLD.trCTM_Value, NEW.trCTM_Value, OLD.trCTM_ItemID, NEW.trCTM_ItemID,OLD.trCTM_Approved, NEW.trCTM_Approved,OLD.trCTM_Expiration_Date,NEW.trCTM_Expiration_Date, OLD.trCTM_Rej_Reason, NEW.trCTM_Rej_Reason, OLD.trCTM_Reviewer, NEW.trCTM_Reviewer, OLD.trCTM_Dose, NEW.trCTM_Dose,OLD.trCTM_Administered_Date, 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, OLD.trCTM_Test_Results, OLD.trCTM_Test_Result_Notes, OLD.trCTM_Next_Step, OLD.trCTM_Complete, OLD.trCTM_Pre, OLD.trCTM_Pre_Date, OLD.trCTM_Post, OLD.trCTM_Post_Date, NEW.trCTM_Record_Type, OLD.trCTM_Record_Type, NEW.trCTM_Status, OLD.trCTM_Status );

    IF NEW.trCTM_Status <> OLD.trCTM_Status THEN
      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 IF;
  END