Automatically populate created date on relationships
Closed, ResolvedPublic
Actions

Description

Let's add automatically populated 'created_date' and 'modified_date' fields on relationships that act like the ones on activities. This could be useful to all CiviCRM users, not just WMF, so we can make the change in Civi core. Here's the upstream change proposal, with a comment in favor: https://lab.civicrm.org/dev/core/-/issues/2938

This ticket originally requested to make the start_date automatically set to the date of the relationship's creation in the database, but since start_date has a specific meaning it feels better to add these new columns.

Details

Subject	Repo	Branch	Lines +/-
Add created & modified dates to relationhsip view	wikimedia/fundraising/crm/civicrm	master	+8 -3
Add created & modified dates to relationhsip view	wikimedia/fundraising/crm/civicrm	master	+8 -3
Update extendedreports	wikimedia/fundraising/crm	master	+137 -790

Customize query in gerrit

Event Timeline

Ejegg created this task.Oct 27 2021, 8:20 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 27 2021, 8:20 PM

XenoRyet moved this task from Triage to Sprint +1 on the Fundraising-Backlog board.Nov 1 2021, 7:46 PM

XenoRyet moved this task from Sprint +1 to Current Sprint on the Fundraising-Backlog board.Nov 23 2021, 9:15 PM

XenoRyet added a project: fundraising sprint Wireless Zipline.Nov 23 2021, 9:23 PM

• DStrine triaged this task as Medium priority.Dec 3 2021, 5:19 PM

• DStrine removed a project: fundraising sprint Wireless Zipline.Dec 7 2021, 8:15 PM

• DStrine moved this task from Current Sprint to Parking lot (post Q2) on the Fundraising-Backlog board.

• DStrine moved this task from Parking lot (post Q2) to Triage on the Fundraising-Backlog board.Jan 10 2022, 5:59 PM

• DStrine renamed this task from Automatically populate start date on relationships to Automatically populate created date on relationships.Jan 10 2022, 9:44 PM

• DStrine moved this task from Triage to Sprint +2 on the Fundraising-Backlog board.

• DStrine moved this task from Sprint +2 to Sprint +1 on the Fundraising-Backlog board.

• DStrine moved this task from Sprint +1 to Current Sprint on the Fundraising-Backlog board.Jan 18 2022, 9:35 PM

• DStrine added a project: Fundraising Sprint Anti-matter doesn't matter.Jan 18 2022, 9:48 PM

• DStrine added a project: fundraising Sprint Black Hole Fillings.Feb 1 2022, 9:36 PM

Damilare claimed this task.Feb 1 2022, 10:32 PM

Ejegg updated the task description. (Show Details)Feb 2 2022, 5:32 PM

I have done some work upstream to get 2 new fields added to core for this table - created date & modified date - these are maintained using mysql & will be added when we update to 5.47 in the near future. They haven't been added to the UI yet (which should be done in core).

https://lab.civicrm.org/dev/core/-/issues/2938

Sorry for not updating the ticket earlier!

Damilare reassigned this task from Damilare to Eileenmcnaughton.Feb 3 2022, 10:50 AM

Damilare subscribed.

jgleeson moved this task from Backlog to Done on the fundraising Sprint Black Hole Fillings board.Feb 7 2022, 2:31 PM

Eileenmcnaughton moved this task from Done to Review on the fundraising Sprint Black Hole Fillings board.Feb 15 2022, 8:11 PM

Eileenmcnaughton moved this task from Review to Doing on the fundraising Sprint Black Hole Fillings board.

• DStrine added a project: Fundraising Sprint Cheese String Theory.Feb 15 2022, 8:50 PM

Eileenmcnaughton moved this task from Backlog to Doing on the Fundraising Sprint Cheese String Theory board.Feb 16 2022, 2:24 AM

Change 762973 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Update extendedreports

https://gerrit.wikimedia.org/r/762973