Add activity created date in Form Builder
When adding a Search Form in Form Builder, the available Activity Fields has "Activity Date" which is separate from the created date. It would be great to include "Activity Created Date" (or "Created Date"). SearchKit already has this field available in its search.
To reproduce:
- Create an activity with the activity date in the past (activity date occurred on 12/15/2021). CiviCRM records the activity created date as today (12/24/2021).
- Create a "New Search" in Search Kit, showing "Cases" with "Case Activities". Search Kit has the options for two types of activity dates here.
-
Case_CaseActivity_Activity_01.activity_date_time
: The date when the activity occurred. -
Case_CaseActivity_Activity_01.created_date
: The date when the activity was created.
- In Afform, only "Activity Date" shows up which references
activity_date_time
, but there's no option to addcreated_date
(see image below). Therefore, afform only can filter by activity date and not the created activity date.