脸谱网:FQL获取所有签到中的me()被标记为 [英] Facebook: FQL get all checkins me() is tagged in

问题描述

我想获取标记了用户的所有签到(注意:我对他自己的签到不感兴趣).我尝试了以下方法，这有点不合逻辑，当然不起作用，但是您会得到我想要做的事情:

I want to get all the checkins a user is tagged in (note: I am not interested in his own checkins). I tried the following, which is a little illogical and of course does not work, but you'll get what I am trying to do:

SELECT message FROM checkin WHERE tagged_uids IN 
(SELECT uid FROM user WHERE uid = me())

有什么想法吗?

推荐答案

您正在考虑向后IN.您要查找的查询是:

You're thinking of IN backwards. The query you're looking for is:

SELECT message FROM checkin WHERE me() IN tagged_uids

，tagged_uids是不可索引的，因此您需要先了解更多信息，然后才能运行此查询(例如谁实际记录了签入内容).您可以尝试的一件事是:

However, tagged_uids is not indexable, so you'll need to know more information before you can run this query (like who is actually recording the checkin). One thing you could try is:

SELECT message FROM checkin 
WHERE author_uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND me() IN tagged_uids

这将查找该用户的朋友(可能是唯一仍可以签入该用户的人)在其中标记了您的用户的所有签到.

This will find all checkins in which your user is tagged that are by friends of the user (probably the only people who can check in that user anyway).

这篇关于脸谱网:FQL获取所有签到中的me()被标记为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！