FQL获得喜欢的艺术家 [英] FQL get liked artists
问题描述
使用FQL可以获得用户喜欢的艺术家(音乐)吗?我检查权限,我找不到与之相关的任何东西,我不是Facebook用户,所以我不知道是否有可能。
喜欢
表格不会回馈兴趣,但是:
一个FQL表,返回喜欢给定对象
(视频,注释,链接,照片或相册)的用户的ID。
这不是我们需要的。
第一种方式 - 快速描述
在 用户
表格中,您将找到一个音乐
字段,它发送包含所有喜欢的艺术家的一行。查询将会像以下一样简单:
SELECT音乐FROM用户WHERE uid = me()
{
/ pre>
data [
{
music:Macarize,MARCEL DETTMANN,Alan Fitzpatrick
}
]
}
第二种方式 - 详细结果
由
Page_fan
表,我们一个一个地获得用户的音乐兴趣。SELECT名称,键入FROM页面WHERE page_id IN(
SELECT page_id FROM page_fan WHERE uid = me()AND profile_section =music)
{
data:[
{
name:Macarize,
type:RECORD LABEL
},
{
name:MARCEL DETTMANN,
type:PRODUCER
},
{
name:Alan Fitzpatrick,
type:MUSICIAN / BAND
}
]
}
Is it possible, using FQL, to get the liked artists(music) of a user? I check the permissions and I couldn't find anything related to it and I am not a facebook user so I am not sure if it's even possible.
解决方案The
Like
table doesn't give back the interests, but:An FQL table that returns the IDs of users who like a given object (video, note, link, photo, or album).
That's not what we need.
First way - Rapid description
In the
User
table, you'll find amusic
field which sends back one line containing all the liked artists. The query would be as easy as:SELECT music FROM user WHERE uid = me()
{ "data": [ { "music": "Macarize, MARCEL DETTMANN, Alan Fitzpatrick" } ] }
Second way - Detailed results
By the
Page_fan
table we get the user's music interests one by one.SELECT name, type FROM page WHERE page_id IN ( SELECT page_id FROM page_fan WHERE uid=me() AND profile_section="music")
{ "data": [ { "name": "Macarize", "type": "RECORD LABEL" }, { "name": "MARCEL DETTMANN", "type": "PRODUCER" }, { "name": "Alan Fitzpatrick", "type": "MUSICIAN/BAND" } ] }
这篇关于FQL获得喜欢的艺术家的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!