Facebook FQL nested SELECT field value -
if have query nested query:
select name, start_time event creator in (select page_id, name place distance(latitude, longitude, "59.436961", "24.753575") < 100) limit 1
output:
{ "data": [ { "name": "join club – james werts live", "start_time": "2014-06-29t23:00:00+0300" } ] }
so have name of event, how can "name" field in query "place" table?
in sql, do:
select event.name, place.name event, place
but fql quite limited , lets either select ... event
or select ... place
.
so in case, not able place name place
table, host
field event
table, contains same information:
select name, start_time, host event creator in (select page_id place distance(latitude, longitude, "59.436961", "24.753575") < 100) limit 1
result:
{ "data": [ { "name": "join club – james werts live", "start_time": "2014-06-29t23:00:00+0300", "host": "venus club" } ] }
Comments
Post a Comment