MAX aggregation in Views on Date fields displays blank

Created on 26 May 2021, over 3 years ago
Updated 3 December 2023, about 1 year ago

Problem/Motivation

If I create a View showing Date fields from CiviCRM entity, and apply MAX Aggregation, the display is blank. Without aggregation it displays OK; COUNT aggregation works OK; the MAX field shows a date style formatter, but output is blank.

Steps to reproduce

This is on Drupal 8.9.15, CiviCRM 5.36.1, Civicrm_Entity 8.x-3.0-beta3. I have also applied the patch in https://www.drupal.org/files/issues/2021-05-23/drupal-date_field_views_a... to deal with a different date aggregation problem.

I have observed this on the 'Start Date' field in an Event record, and the 'Modified Date' field in a Contact record. At the MySQL structure level the first is a 'datetime' and the second a 'timestamp'.

Test View files attached.

Proposed resolution

I don't know if this is a CiviCRM_Entity problem or a Drupal Views problem. Please advise if this should be redirected to Views.

🐛 Bug report
Status

Active

Component

Code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024