Posted by pribeh on June 27, 2009 at 3:04pm
| Project: | Flag Friend |
| Version: | 6.x-1.0-beta5 |
| Component: | Miscellaneous |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Hey Guys,
This looks like the module I'm going to switch over to but I need to make sure this request is in the Q - as I can't find it. I'm working on a social networking site that resembles facebook/twitter and I need a module which provides a handler to views that will allow for the display of both the user's content (being viewed or otherwise) and their flagged friend's content. I need this to be integrated with both activity (2.0) and facebook statuses.
Issue was just brought up with facebook status maintainer here: http://drupal.org/node/495730#new
Excellent work. Flag, Flag-friend, activity (2.0) and fb statuses will let any drupalite create a facebook/twitter platform.
Comments
#1
use the filter Activiity: type > node and Activity Access: Flag Friend
#2
I can find filter for "activity type: node" but not for "activity access: flag friend" option when creating a view with activity 2.0. Is this available for activity 2.0? Thanks for your help Scott.
#3
sorry for reopening this issue but I seriously can't find the filter "activity access: flag friend".
#4
admin/settings/activity/settings (the first screen shot attached)
then configure the View Filter
#5
Hmmm, I'm definitely not seeing anything but "comment: comment" under the activity control on activity's settings page. Perhaps this is a sql issue? I'm testing a local (6.12) version of a live site with a fresh copy of activity (2.x-dev), flag (1.1) and flag_friend (1.0-beta5) installed - with all the subsequent versions uninstalled first. I'm going to install a clean Drupal 6 site and try again.
#6
Ok, so no progress made on this. I triple checked to make sure my sql is running correctly. I don't know what could be conflicting. Any guesses? Should I open this as a separate issue, perhaps as an activity issue thread?
#7
Using the latest dev of Flag_Friend I found the "flag_friend" access checkbox in Activity settings. I'm not achieving anything yet though. Here's what I'm doing:
I'm using the "activity access: flag friend" on a clone of the basic "all_activity" view. Then I throw this view into a user profile panel (using panels 3). So far I don't know what argument to use to identify the user (who's profile is being viewed). I've tried "activity: actor" and "user: ID" but without success.
Here's what I'm trying to achieve:
Setup a view that displays all of a user's activity (facebook status updates + node inserts) plus their friends' activity all within a single view that sits on their user profile page (sort of like facebook or twitter does it).
Any help is much appreciated. Thanks.
#8
I am also apparently not getting this...
Flag 6.x-1.1
Flag Friend 6.x-1.x-dev (2009-Aug-13)
Activity 6.x-2.x-dev (2009-Aug-05)
Without any relationships or filters added, we get all activity for all users in Views (using a clone of the "all_activity" view)
"Flag Friend: Friend" checked at admin/settings/activity/settings
Filter set to Activity Access: Friend Flag Access = Friend
...gets no results at all.
Adding a Flag Friend: Friend relationship also gets no results (and I've tried every combination of settings in the relationship configuration)
Could someone post a working Views recipe from beginning to end for this? It would be most appreciated.
Thanks!
#9
We figured out what was happening with our setup - stupidly, I hadn't done anything on the site to set off any triggers, after having turned on the flag friend activity access control. Once triggers were set off, things started to appear in the view. duh.
For those trying to figure this out, #4 above is the recipe:
admin/settings/activity/settings/:
* set flag friend activity access control to checked
Views:
* set an Activity Access: Flag_Friend Access filter on your view
simple as that.
#10
Good. Could you export your View and put it here. Then we can close this issue.
#11
Hi, thanks so much for all your hard work Scott Reynolds but I think in order to achieve what I was looking for you need to have the filter Activity Access: Flag_friend Access = and Activity Access: Allow Access to the Actor = ...
I've attached a view.
#12
yep this is true and on purpose.
#13
I tried out this view and unfortunately using the filter method causes HUGE query build times for my site... I have over 20k friends though so that is the reason but still even with a few hundred the query is heavy. There has got to be a better solution, maybe some type of join instead of this concatenation...
Query build time 35260.17 ms
Query execute time 10720.46 ms
View render time 5.85 ms
#14
Can you elobrate?
This View can be affect by a number of different factors. Can you post the EXPLAIN of the resulting querying? http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
I am willing to bet that if you remove the CCK fields you will see a vast improvement. This is because of this issue, not related to flag_friend or activity: #372994: Ability to INNER JOIN to node for a specific field. In this case its doing an ACCESS ALL on the Activity table instead of the node table (which could be considerably larger making it considerably worse).
If this is the case, I would encourage you to change the content type Views table to do an INNER JOIN instead of a LEFT JOIN on the node base table. Much like webchick did: #372994-11: Ability to INNER JOIN to node for a specific field
If removing the CCK fields from the View doesn't work please open a new issue against Activity and remove various fields until the query is suitable. That will allow us to isolate the field if that is the problem.