FbDevWiki is for sale on Flippa. Please take a look at the page if you're interested. There's only a few days left to the auction!

FQL:status

From Facebook Developer Wiki (FbDevWiki.com)
Jump to: navigation, search

Query this table to return one or more of a user's statuses.

Columns

Highlighted rows are indexable / searchable and one is usually required in the WHERE portion of the query.

Name Type Description
uid int The user ID of the current user.
status_id string The ID of the status message.
time string The date and time the status message was posted.
source string The application that published the status originally.
message string The content of the status message.

Examples

Optimization: When querying this table for many users, be sure to give specific time limit within the last week. For example, instead of running this query:

SELECT uid,status_id,message FROM status WHERE uid IN (SELECT uid2 FROM friend WHERE uid1= uid)

Run this query instead:

SELECT uid,status_id,message FROM status WHERE 
   uid IN (SELECT uid2 FROM friend WHERE uid1= uid) 
   AND time > {time in the last week}.

The status table is limited to the last 30 days or 50 posts, whichever is greater.

See Also

Personal tools
Namespaces
Variants
Actions
Navigation
Graph API
FQL
Toolbox