Why doesnt the query work?

Question

I want to find the name, pic and page_url of the pages which installed my application.

So I created this query:

SELECT pic, name, page_url FROM page WHERE page_id IN (SELECT page_id FROM page WHERE has_added_app = 1)

What's wrong? I understood that the "WHERE" has to be with indexable parameters - "page_id" is indexable parameter but "has_added_app" is not.. but I have to use it.. so how do I do it?

Thank you.

Answer 1

It appears that you can't get this information. A thread on the developer forum on facebook.com http://forum.developers.facebook.net/viewtopic.php?pid=237709

You could return the data in JSON format and include the has_added_app You could then maybe use some funky Javascript to determine if its true or not. No idea if this is possible though.

Or there is always the Old Rest Api pages.getInfo or pages.isAppAdded

Full Facebook FQL reference page