CRM-885 Add "Last Changed" Information To UF Profile Objects

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.4
    • Fix Version/s: Unscheduled
    • Labels:
      None

      Description

      I'm working on creating a JasperReports-based reporting solution for CiviCRM. Because of the way Jasper works, we need to cache report and field definitions that are derived from CiviCRM profiles. This makes it very desireable for us to determine if a profile object has been changed since we last pulled down its definition and compiled it into a Java object. This a appears not to be possible currently, or at least, it seems hard to do.

      It would be very useful for this and other reporting software if a "last modified" field was added to the data model for a UF Profile Group, and that the API gave us some way to get at this information.

        Attachments

          Activity

          [CRM-885] Add "Last Changed" Information To UF Profile Objects
          Donald A. Lobo added a comment -

          we are planning to introduce a created by / modified by (in the db) system in 1.5. however, profile groups dont really fall under this model since "profile fields are added/deleted from a group" without touching the group table.

          An easier solution might to to compute a md5 hash of the profile fields and cache it on the "report" side, and periodically recompute it. I suspect keeping track of changes is more a responsibility of the client than the server

          Dharmatech added a comment -

          Closing as of 4.0.7, European Code Sprint 12/2011.

          Issues identified have been addressed by way of bug fixes, features/improvments or are no longer relevant.

            People

            • Assignee:
              Donald A. Lobo
              Reporter:
              Rob Thorne

              Dates

              • Created:
                Updated:
                Resolved: