unified_thread_count - Facebook Developers

Description

Provides the number of threads in a specific folder.

Columns

Name	Description
folder string	Folder name ('inbox', 'other' or 'spam')
last_action_id string	The highest action ID of a thread in a particular folder. The value increases as new messages are added. This can be useful for checking whether there are any new threads in the folder
last_seen_time string	Last time the folder was accessed (UNIX timestamp, in milliseconds)
refetch_action_id string	Refetch action ID of a thread in a particular folder. If your cached action ID is lower than this value, you should do a full refetch instead of syncing incrementally via `unified_thread_sync`
total_threads unsigned int32	Total number of non-archived threads
unread_count unsigned int32	Number of unread threads in the folder
unseen_count unsigned int32	Number of unseen threads in the folder

Examples

SELECT ... FROM unified_thread_count WHERE folder = A
SELECT ... FROM unified_thread_count WHERE unread_count = A
SELECT ... FROM unified_thread_count WHERE unseen_count = A
SELECT ... FROM unified_thread_count WHERE last_action_id = A
SELECT ... FROM unified_thread_count WHERE last_seen_time = A
SELECT ... FROM unified_thread_count WHERE total_threads = A

Note: Additional filters on other columns can be specified but they may make the query less efficient.

Permissions

Access to this table requires the read_mailbox extended permission.