Geek Answers Handbook

How to filter by category in FQL

As you can see here ,

Companies have information about their category: local business, sports, education, etc. This is the category field.

I would like to know if there is a way to filter companies by their category and position using FQL? I did not find how to do this. For example: give me the entire sports center in this circle (lat, womb, radius).

thanks

+6
facebook facebook-fql
source share
3 answers

I was looking for something and did not find anything. It seems that only the api table has category information for the page.

+1
source share

The category attribute in the page table is called type. Here is a query to filter the registered user "local business":

SELECT page_id, name, description, type, pic, fan_count

From page

WHERE

page_id IN (SELECT page_id FROM page_fan WHERE uid = me ())

& Type = 'LOCAL BUSINESS'

Run example

+6
source share

You cannot receive pages by category.

The FQL Page table has a field called categories.

You can get a category for business using FQL as follows:

SELECT categories FROM page WHERE page_id = PAGE_ID

where PAGE_ID is the identifier of the Facebook page.

However, categories are not an indexable field. You cannot ask for all cases in New York that are Florists, since "WHERE categories = florist" is not permitted.

+5
source share

More articles:


All Articles