Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13028

Adv logging: Refine triggers for tables with datestamps

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.4.0
    • Fix Version/s: 4.4.0
    • Component/s: NYSS
    • Labels:
      None
    • Funding Source:
      Core Team Contract

      Description

      Spec from nyss#6933
      =====================
      A few of the tables currently being logged contain specific columns that store a datestamp or cache-type value that is updated frequently. as a result, the row is updated in the log table more frequently than we need. we want to continue to log those tables, but refine the trigger so that we ignore updates to those particular fields.

      specific tables to look at include:
      log_civicrm_job
      log_civicrm_group

      Patch: 1st file of https://github.com/nysenate/Bluebird-CRM/commit/3039742460b681871e0e1b34a9e7fdbe6ba50d83.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                lcdweb Brian Shaughnessy
                Reporter:
                deepak Deepak Srivastava
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h