Field "Comment Statistics: Updated/commented date" is build correctly:
GREATEST(node_field_data.changed, comment_entity_statistics.last_comment_timestamp)

Filter Criteria seems to use the old/wrong row "node.changed":
GREATEST(node.changed, comment_entity_statistics.last_comment_timestamp)

So this SQL-Error arises:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node.changed' in 'where clause': SELECT

#2 2879923-2.patch756 bytesLendude


kle created an issue. See original summary.

Lendude’s picture

Component: views.module » comment.module
Status: Active » Needs review
Issue tags: +VDC, +Needs tests
756 bytes

@kle thanks for the bug report. And yes this is broken.

Here is a fix, this still needs tests.

Moving to the right component, the code for this lives in the comment module.

dawehner’s picture

I'm wondering whether we can search the codebase for other instances of it, and as such fix the failures earlier than needed.