Adding a latest comment to a view
I need some help getting a view set up properly. On my homepage I have a view that displays the latest ten news items. The items are displayed like so:
[title]
Submitted by [name] on [created]
[teaser]
This is pretty straightforward. What I want to do is add the body of the latest comment (if there is one) at the bottom. So it would look like this:
[title]
Submitted by [name] on [created]
[teaser]
[latest comment]
Perhaps I'm missing it, but there doesn't seem to be any way to display the latest comment. There's an option to display the body of a comment using [comment] == Comment: Body, however, that causes the node to be duplicated for however many comments there are. If there are 25 comments then the node gets duplicated 25 times. Is there no simple way to display the latest comment in a view? I would think that would be something used commonly in a lot of drupal sites.
The 'comment_recent' view
The 'comment_recent' view needs to be enabled which works for the comments of the node, then more Node fields can be added as per requirement.
Comment_recent can find from here : Home >> Administer >> Site building >> views
That doesn't really work as
That doesn't really work as it generates a list of comments which can have nodes attached to them, rather than a list of nodes with the latest comment attached. If there are five comments on that story, you end up with five duplicates of the same story on the homepage.
_
Not sure if this will work and it seems a little odd, but what about adding a viewfield to the node itself that displays the comment you want then adding that field to the node view....
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.