BugsFQL with IN-statement only returns results for 1 user in the subquery
- Status: Fixed
- Priority: Medium
- Updated: August 29, 2012 at 2:01pm
Latest response from Facebook
Jeff Bowen
This issue was resolved in mid-July. Thanks for your patience.
Status changed to Fixed · August 29, 2012 at 2:01pm
Samantha Gruskin
Thanks for the report. We are looking into this.
Status changed to Assigned · Priority changed to Medium · June 19, 2012 at 12:16pm
FQL Query for User Owned Photos Broken, Fetching all photos by FQL returns only photos from last album, and 3 others, Fql, fql stream with multiple source_id, and FQL with IN-sta were marked as duplicates of this bug.
I want the application to get photos from all my friends, and have created the following subquery:
SELECT owner, object_id, like_info FROM photo WHERE aid IN (
SELECT aid FROM album WHERE owner IN (
SELECT uid2 FROM friend WHERE uid1=me()
)
)
This subquery only returns pictures from one of my friends that are found in the inner subquery; instead of photos from all my friends.
Duplicate of: https://developers.facebook.com/bugs/471620432865189
Reason: Last bug-report is rather bad.
SELECT owner, object_id, like_info FROM photo WHERE aid IN (
SELECT aid FROM album WHERE owner IN (
SELECT uid2 FROM friend WHERE uid1=me()
)
)
This subquery only returns pictures from one of my friends that are found in the inner subquery; instead of photos from all my friends.
Duplicate of: https://developers.facebook.com/bugs/471620432865189
Reason: Last bug-report is rather bad.
| Steps to Reproduce: | 1: Go to https://developers.facebook.com/tools/explorer 2: Click "Get access token" and get a token with following permissions: - User_photos - read_friendlist - friends_photos 3: Click on FQL-query 4a: Insert following query: SELECT owner, object_id, like_info FROM photo WHERE aid IN ( SELECT aid FROM album WHERE owner IN ( SELECT uid2 FROM friend WHERE uid1=me() ) ) 4b: Or just visit: https://developers.facebook.com/tools/ |
|---|---|
| Expected Behavior: | Expect the query to give me a list with photos from many different friends. |
| Actual Behavior: | Only returns a list with photos from one of my friends in the subquery- |
| API/SDK: | FQL |
| App IDs: |
|
14 people can reproduce this issue by following these steps
Repro