Hello, when executing the following query: SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_type, change_status.ad_group_criterion, change_status.resource_status FROM change_status WHERE change_status.last_change_date_time >= '2021-11-07 01:59:59.9999999' AND change_status.last_change_date_time <= '2021-11-08 12:00:51.7769511' AND change_status.resource_type = 'AD_GROUP_CRITERION' ORDER BY change_status.last_change_date_time LIMIT 10000 we receive data starting with last_change_date_time beginning with values '2011-11-07 01:10:50.726134'
however for query SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_type, change_status.ad_group_criterion, change_status.resource_status FROM change_status WHERE change_status.last_change_date_time >= '2021-11-07 02:00:00.0000000' AND change_status.last_change_date_time <= '2021-11-08 12:00:51.7769511' AND change_status.resource_type = 'AD_GROUP_CRITERION' ORDER BY change_status.last_change_date_time LIMIT 10000 we receive only one record beginning at 2021-11-08 09:22:23 Please draw your attention to the first query where specifically we ask for data change_status.last_change_date_time >= '2021-11-07 01:59:59.9999999' yet receive data with timestamp less than that filter this results in a time loop where we take the last received timestamp in a batch for 10k and use that in the next query for the next batch of 10k only to get the same batch we just requested. We are stuck in a time loop. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/b2864864-114e-4808-a0be-30100d41dcf9n%40googlegroups.com.
