Does created_time provide a way to bypass the 30-day limit on stream data?

I just want to confirm this.

FQL documentation is somewhat vague as it indicates

Each thread table query is limited to the previous 30 days or 50 messages, whichever is greater

then state

You can use time-specific fields, such as created_time, as well as FQL operations to receive a much larger number of messages

Given this statement, it would seem that you could use created_time to retrieve 50 units of stream data at a time, regardless of date, if time is specified. However, in practice, it looks like I'm always limited to the last 30 days.

Running this query returns 0 records:

SELECT message FROM stream WHERE filter_key = 'owner' AND created_time < 1325376000 LIMIT 50' 

1325376000 is the timestamp for '01 / 01/2012 '. created_time not exceed the 30 day time limit? I'm just looking for a definitive answer. Thanks.

+4
source share
1 answer

Not sure how filter_key = 'owner' ; but I was able to confirm that with the source_id column you can go back and return records older than 30 days.

eg -

 SELECT message, created_time FROM stream WHERE source_id = me() AND created_time < 1325376000 LIMIT 50 
0
source

Source: https://habr.com/ru/post/1402757/


All Articles