Reply to comment
- Not Just a Contact Database
-
These optional components give you more power to connect and engage your supporters.
civiCASE
Case management for clients and constituents.
civiCONTRIBUTE
Online fundraising and donor management.
civiEVENT
Online event registration and participant tracking.
civiMEMBER
Online signup and membership management.
civiMAIL
Personalized email blasts and newsletters.
civiREPORT
Report generation and template management.
Using a start_date to review contact at a point in time
If every logged object has a start_date, wouldn't that enable you to find the state of a contact at a particular point in time by:
(a) determining if the object's start_date is before relevant point in time - if yes, the current values are the right ones for that point in time; and
(b) if no, looking through the log table for that object where the start_date is before the relevant point in time and the log_date is after - that record will have the right values for that point in time.