Filter Submissions/OData by submission date about central

[ggalmazor]

Related to this issue: while working on Briefcase v.16 we found that we can't support using a date range filter when exporting a form because it relies on Aggregate adding a submission date to the submission contents.

This won't prevent users from exporting all submissions, but we know there are users with large forms that need this to streamline their data management scripts by exporting fewer submissions each time.

getodk/briefcase#736

[issa-tseng]

to clarify, you’re just providing historical context about aggregate’s limitations, yeah? you’re not saying you ran into a problem that will prevent central from providing this feature?

…

On Jun 26, 2019, at 01:07, Guillermo Gutiérrez ***@***.***> wrote: Related to this issue: while working on Briefcase v.16 we found that we can't support using a date range filter when exporting a form because it relies on Aggregate adding a submission date to the submission contents. This won't prevent users from exporting all submissions, but we know there are users with large forms that need this to streamline their data management scripts by exporting fewer submissions each time. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[ggalmazor]

Ugh, I realize that my comment was super hard to follow :/ In my defence I'll say that I think I hadn't had my first coffee yet :P

What I wanted to say is that we found that Central does not add a submission date to the submissions, which makes it impossible for Briefcase users to export them with a date range filter.

Of course, correct me if I'm wrong, please ;)

Aggregate does add submission date metadata to submissions, which was used by Briefcase to implement the date range filter for exports.

[issa-tseng]

central does not inject a submission date into the submission itself, but it does know that date, and it provides it on the REST API, on the OData export under __system metadata, and in CSVZIP export as an additional column at the end.