No way to identify 'deceased' contacts when viewing or reporting on relationships
Overview
Marking a contact record as 'is_deceased' doesn't currently appear to have any impact on the contact's relationships, which makes sense overall (for example, if a contact was marked as deceased and then a scheduled job were to automatically expire all it's relationships, it would be very manual and annoying to reverse that if 'is_deceased' had been added by accident. However, it would be extremely useful (a) when viewing relationships on contact records and (b) when reporting on relationships, to know whether one of the contacts involved in the relationship is deceased.
Example use-case
On a contact record:
- Create a contact (contact A)
- Add a relationship to another contact (contact B)
- Mark contact A as deceased
- View relationships tab on contact record for contact B
Within reports:
- Go to create new relationships report (/civicrm/report/instance/5?reset=1&output=criteria)
- View columns/ filters tabs; no configurations available relating to 'is_deceased'
Current behaviour
On a contact record:
- No change to relationship (or relationship display) when one of the contacts is marked as deceased
Within reports:
- As described above
Proposed behaviour
On a contact record:
- Propose that - on the relationships tab of the contact record - after the name of the contact that is deceased is added in red "(deceased)" in the same way that it is added next to the main display name at the top of the contact record for a deceased contact currently.
On reports:
- Propose that a filter is added so that 'deceased' contacts can be excluded from relationships reports