Views 2.x - creating table of unread comments

Events happening in the community are now at Drupal community events on www.drupal.org.
dreadstar's picture

Im quite new in using views module and Im quite sure this request is quite basic but Ive spent around 2 days searching thru the database of drupal.org finding no answers. Since this is somewhat a newbie question.

I would like to create a table of unread comments. Based on my research, this is best and easily done by Views module. Ive got it halfway working but got stuck on 2 issues.

Problem #1
Unread comments are being listed every instance rather than just the latest one. For example, if a page node has 5 new unread comments since last visit, this should be listed by views as 1 entry rather than 5 times. What should be in the filter to just show the latest unread comment of a node?

Problem #2
I would also like to filter out comments by the current logged in user. I know I should be filtering author id or name but how to do this since the current logged user is not a constant name. I tried:
- did not work
$user - did not work either

<?php
$user
->name; $myID = $user; echo $myID
?>
- I had to try it ... 8-)
.... and countless variations

Test site using views 2.x on drupal 6.9. Since this is somewhat a newbie question, was hoping of getting some help from friendly kababayans rather than risk getting flamed posting this question on drupal.org.

Philippines

Group organizers

Group categories

Post category

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week