VIEWS - Filter comments to only display latest in table of views
Hi,
I'm using the jobtrack (now known as the support module) and views to generate a list of recent active jobs that have being posted. To accept a job someone adds a comment as per the normal workflow of the module. To close that job once its complete the user adds another comment again this is the correct operation of the module.
My problem is with the view I have generated to display these jobs. At present everytime a comment is added the table of my view adds another duplicate line of the node for each individual comment. So if there are, for example, 3 comments per node I have 3 pretty much identical lines on my views table the only difference being the commented dates/times.
Is there any way I can filter my view to just display the most recent commented date/time and not generate a duplicate for each comment?
I hope that all makes some sort of sense I'm sure its easily done I just can seem to get it to work.
Thanks,
Paddy
Me too - anyone?
I have a list of nodes pulled in Views by way of a couple of filters. Below each node listing, I want to display a single comment - the most recent. In Views, by selecting Fields, I have the option of displaying the most recent comment-ER, the date it was posted, but not the comment itself. If I select comment Body, I get ALL comments. Is there any way to just have the most recent comment body displayed in a node view?
I tried creating a comment view separately which took a node id as an argument. I then built a tpl.php template to correspond to my original node view (the one in which I wanted to be able to select recent comment body, but couldn't), and included a call to views_embed_view() right beside print $row inside the template file. But I can't find a way to dynamically pass the node id to that function so that it corresponds exactly to the nodes being selected by the original node view.
Right now, I think my only option is to include logic in template.php that spits out exactly the same nids as the original view obtains by way of its filter, and then to implement views_embed_view() inside a loop which will cycle through that array of nids as arguments to pass.
Any better solutions would be very welcome!
Chris