The query expression in src/Plugin/views/field/ReportDateField.php query() works for MySQL but not PostgreSQL.
The line $expression = $this->query->getDateFormat("FROM_UNIXTIME($this->tableAlias.$this->realField)", $this->dateFormatString);
needs to be $expression = $this->query->getDateFormat("TO_TIMESTAMP($this->tableAlias.$this->realField)", $this->dateFormatString);
Not sure how to achieve that in DB independent way - maybe use getDateField()
Linked to https://www.drupal.org/project/commerce_reports/issues/2944508 →
Needs review
1.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
@thtas is this still an issue 5Y later? Or fixed in dev already?
The site we're running this on is using commerce_reports 1.0.0-beta2 + this patch (and some others) and working well.
But as mentioned, running on mariadb, not postgres.