Some PostgreSQL functions to retrieve data from an ODK Central server to PostgreSQL tables.
GNU General Public License v3.0
22
stars
9
forks
source link
Filtering data to not always get all data from central #10
Open
mathieubossaert opened 2 years ago
Possibilities (maybe other possible) : -> see https://github.com/getodk/central-backend/issues/391
Make use of __system/submissionDate filter over subtables once it will be possible from the last 2 days (for example)
Or use it in combination with $expand=* option
filtering ReviewState (new state to purpose to the team or use the actual ones (ie "approved" for all downloaded submission) ?
get submissions one by one with their Submission ID ?