Uploaded image for project: 'CiviVolunteer'
  1. CiviVolunteer
  2. VOL-297

Add "created" and "last updated" columns to the needs table

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.2.1
    • Fix Version/s: 4.7.21-2.3.0
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      User and Admin Doc
    • Verified?:
      No

      Description

      Add "created" and "last updated" columns to the needs table. The need for this change arose because a client wishes to send automatic match notifications, taking the "freshness" of the opportunity into account. It could also be used to build custom displays (e.g., "recently added volunteer opportunities).

      "Last updated" can be automatically updated at the SQL level. "Created" will need to be managed in the BAO, since in versions of MySQL < 5.6.5, it is not possible to have the current timestamp be the default value for one column and the auto-update value for another column.

        Attachments

          Activity

            People

            • Assignee:
              pittstains Frank J. Gómez
              Reporter:
              pittstains Frank J. Gómez
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: