Hi @Matthew_White , I am still trying to pull only fresh data from central in order to not download every hour all the data collected since march (Propagate submission date to child tables - #3 by mathieubossaert).
As @Florian_May said, getting all data every day or every hour works fine, but I am looking for a solution that do not consume resources for nothing in our "real time" data collection workflow)
So a few days ago I read your post with most attention than I did and I thought I found the solution.
I adapted my sql function to get submissionId from central that are relevant to filters I give (with submissionDate, updatedAt et reviewState parameter.
It's works fine but I fear it only works for a "one level" repeat form ?
My form contains a "observations" repeat nested in the "location" one. So I achieve to automatically get data for the significant instanceId for both submission and location table but not for observations one.
Am I wrong ?