FQL:unified_thread_count

From Facebook Developer Wiki (FbDevWiki.com)
Jump to: navigation, search
Please note: Facebook is in the process of making the new messages system available to all users. Facebook is providing early access to this API for registered developer accounts only until the new messaging system is broadly available. You should use the message table and thread table for production applications at the current time.

Access to this table requires the user to grant the read_mailbox extended permission.

Columns

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

Name Type Description
folder string Folder name ('inbox', 'other', 'spam' or 'sent').
unread_count int Number of unread threads in the folder.
unseen_count int Number of unseen threads in the folder.
last_seen_time int Last time the folder was accessed (Unix-type timestamp with millisecond resolution).
total_threads int Total number of non-archived threads.

Examples

Get thread counts for the inbox folder

SELECT ... FROM unified_thread_count WHERE folder='inbox'

Get thread counts for all folders

SELECT ... FROM unified_thread_count WHERE 1
Personal tools
Namespaces
Variants
Actions
Navigation
Graph API
FQL
Toolbox