akvo / akvo-mis / #625

88%

main: 88%

Pull #215

coveralls-python

[#214] Fix date range filter for flow-imported data in list API and zip download

- Fix `latest_child_activity` annotation to use `Coalesce(updated, created)`
  so flow-imported children with `updated=NULL` contribute their `created`
  date instead of NULL, preventing registrations with recent monitoring from
  being excluded by the date filter
- Fix `latest_child_form_subquery` ordering to use `Coalesce(updated, created)`
  so NULL-updated records are ranked by `created` rather than sorted first
- When `sort_by=latest_activity`, apply date filter to the annotated
  `latest_activity` field so registrations with recent monitoring children
  are included even when the registration itself predates `date_from`
- Add `filter_child_form_ids` param to `download_data` and
  `generate_data_sheet` to separate "which children determine parent
  inclusion" from "which children are merged into rows"
- In `_generate_zip_download`, pass `filter_child_form_ids=child_form_ids`
  when generating the registration sheet so the union approach
  (parent in range OR child in range) applies even though monitoring
  columns are not merged into the registration sheet
- Add tests: `test_null_updated_child_uses_created_for_latest_activity`,
  `test_date_filter_uses_latest_activity_when_sorting_by_it`,
  `test_date_filter_uses_created_when_not_sorting_by_latest_activity`,
  `test_zip_registration_included_when_monitoring_in_date_range`

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>

4987 of 5818 branches covered (85.72%)

Branch coverage included in aggregate %.

9625 of 10778 relevant lines covered (89.3%)

0.89 hits per line