Posted by mgenovese on August 6, 2007 at 3:26am
I am using the Views module to show me a short list of new forum comments (e.g. filter by the forum taxonomy, and select comments sorted by date).
However, what I am really after is a single listing of "forum activity", which includes all new/recent comments AND topics. Right now, I can either get a listing of one or the other, but not both.
Ideas?
Cheers.
Comments
=-=
May need to write a custom DB query to pull this idea off. Seems to me that it would be a very resource intensive operation.
_____________________________________________________________________________________________
give a person a fish and you feed them for a day but ... teach a person to fish and you feed them for a lifetime
Well, I think it'd be no
Well, I think it'd be no more intensive than having two separate views on the same page, one looking for most recent comments, and the other looking for most recent forum nodes.
If custom code is the way to go, can someone give me a hint about getting started? I'm quite new to Drupal here and could use a hand-up.
Thanks.
I'm looking for something
I'm looking for something similar here. I have two views that I essentially want to become one view. I looked at Views Fusion but it doesn't seem to work in this manner (unless I'm missing something)
Me Too
I'm in need of this as well and Views Fusion has been suggested to me as well. Unfortunately, I can't figure out how to get just a view of the forum comments to work to even attempt to fuse with a view of the forum posts (that was easier to put together).
Subscribing.
Curious...
Do your users really put useful titles on all their forum replies? I'd say a good 80% of the time I put "..." for the subject just to avoid having it fill it in with the first few words. To me, it makes more sense to have a list of nodes with new comments rather than listing the comments themselves. I'm curious how many people would find a unified list like this useful? And how, exactly, would it work? Would you list titles of nodes with no comments by themselves and then the titles of individual comments all mixed together in datetime order?
This could be done with straight SQL rather than trying to wrangle views into it. It's not something I really have a need for myself but I could look into how hard it would be to do if there's enough interest.
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
-----
Shell Multimedia - My sporadically updated mostly Drupal blog.
Comment Subjects
Michelle --
I use the Comments Subject mod to fill in my comment titles.
Are you familiar with SMF message board software by chance? What I'm looking for is something to emulate the Recent Posts on that. What is provides is the full body of all posts in descending order so you can see at a glance what is new. You can reply from there at which point you'd go into the thread. And yes, nodes and comments would be mixed together and sorted by date time order. So, basically a quick and dirty way to read all new posts/comments on one screen without having to go into the threads.
My message board is small enough where the users who choose to use it want to read everything that is there and they just find it a pain to have to go into each board to see if there is anything new there. And even though my board is small without a ton of new posts, they are complaining they are missing new posts without this ability.
Ah
That does sound really useful. Ok, I'll work on getting that into advforum.
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
-----
Shell Multimedia - My sporadically updated mostly Drupal blog.
Fantastic!
Michelle, THANK YOU so much!! Please let me know if I can help with testing, CSS/HTML clean-up or whatever. I'm just starting dabble in PHP and really need to get my feet wet with some of this mod work. So, if there are any task you think I can do, I would welcome it for the experience.
...
Well, I spent some time trying to make it work with views and gave up. I'll have to write some custom SQL and my SQL is pretty rusty. But I think I can do it. I'll start with the queries views made. :)
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
-----
Shell Multimedia - My sporadically updated mostly Drupal blog.
Might be a bit
I thought this would be fairly easy but I'm having troubles with it and can't spend any more time on it right now. I'll still do it, but it might be a bit. Figured I should mention it in case people are wondering when it's coming.
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
-----
Shell Multimedia - My sporadically updated mostly Drupal blog.
Thanks again
I can certainly wait. :-) Thanks for taking an interest in this request!