FQL:status

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

• status.set
• status.get