FQL:从流表中检索用户喜欢的对象
正如文档示例中所述,我们可以检索用户的新闻源,如下所示。
SELECT post_id, actor_id, target_id, message FROM stream WHERE source_id in (SELECT target_id FROM connection WHERE source_id= AND is_following=1) AND is_hidden = 0
我想要做的是显示用户的新闻提要,当用户单击“我的”时最喜欢的”,显示摘要(用户喜欢的所有帖子)。
有什么想法吗?
谢谢。
As described in the sample on documents, we can retrieve the user's news feed as below.
SELECT post_id, actor_id, target_id, message FROM stream WHERE source_id in (SELECT target_id FROM connection WHERE source_id= AND is_following=1) AND is_hidden = 0
What I want to do is to display user's news feed and when user clicks "my favorite", display the summary(all posts that a user liked).
Any idea?
Thanks.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
将此条件添加到您的查询中并且 likes.user_likes = 1
你应该得到它。
从示例中,我这样做是为了在墙上获得我喜欢的所有内容:
https://api.facebook.com/method/fql.query?query=SELECT post_id, message, likes FROM stream WHERE source_id = AND likes.user_likes = 1 limit 50&access_token=
同上。
Add this criteria to your query AND likes.user_likes = 1
and you should get it.
From example i do this to get all that i have liked in my wall:
https://api.facebook.com/method/fql.query?query=SELECT post_id, message, likes FROM stream WHERE source_id = AND likes.user_likes = 1 limit 50&access_token=
The same applies to the above.