I am looking for such a field. I have found the "most recent comment date" and "most recent comment author" but can not find the one from this issue title.

I have tried the "comment: content" with grouping turned on but it does not return the most recent one (even with desc sorting on "comment: date" set). Also could not find the proper relationship.

General idea

Maybe there is a way to overcome it. I am trying to make a block with nodes ordered by "most recent comment date" - that was easy. I failed while trying to attach the most recent comment content.

Please help :)

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

Drupal does not contain a pointer to this comment by id, and therefore Views does not contain a feature to utilize it. It requires an annoyingly complex query to find the most recent node, and that query makes things that are normally straightforward suddenly not work.

Drewniacki’s picture

Drewniacki commented

merlinofchaos,

Thanks for explanation!

haleagar’s picture

haleagar commented

also trying to get this and I don't find anything.
No idea how to get it into the view query but in the view generated query replacing
LEFT JOIN dru_comments comments ON node.nid = comments.nid
with
LEFT JOIN dru_comments comments ON node.nid = comments.nid AND comments.timestamp = node_comment_statistics.last_comment_timestamp

gets you just what you want.

haleagar’s picture

haleagar commented

oh I guess you need to be including the field Node: Last comment time in order to have the data to add that AND clause