Reputation: 1243
I'm attempting to execute a semi-advanced query using Facebook's FQL.
SELECT message FROM stream WHERE actor_id= userid_1 AND source_id=userid_2 OR actor_id=userid_2 AND source_id=userid_1
Everytime I run it though, it comes up blank, even though there are posts between the two users on their walls, so this possible or do I need to use some sort of alternative method?
Upvotes: 3
Views: 169
Reputation: 4179
It should work with the combination. Why dont you try with enclosing proper brackets like
SELECT message FROM stream WHERE actor_id= userid_1 AND (source_id=userid_2 OR actor_id=userid_2) AND source_id=userid_1
Upvotes: 2