kobotoolbox / kpi / 21217311342 / 1

81%

master: 76%

push

github

fix(userReports): rename `/api/v2/user-reports/` API fields DEV-1616 DEV-1617 (#6630)

### 📖 Description
This PR updates the `UserReports` materialized view to rename two fields
and add retention context. These changes ensure the API response field
names accurately reflect the underlying data and logic.

Changes:
- `deployed_asset_count` -> `active_project_count`: The previous name
implied a count of all deployed assets, but the metric specifically
tracks projects that are currently active and not archived.
`active_project_count` is a more semantically accurate label for this
data point.

- `total_submission_count.all_time` ->
`total_submission_count.cumulative`: The label `all_time` was
misleading. This value is calculated using the
`DailyXFormSubmissionCounter`, from which old records are periodically
purged based on the `DAILY_COUNTERS_MAX_DAYS` setting. Consequently, the
count reflects a retention window (~12 months) rather than the true
history since inception.

- Added `retention_days`: Added a new field to explicitly expose the
`DAILY_COUNTERS_MAX_DAYS` setting, allowing super users to understand
the time window represented by the cumulative count.

6987 of 11322 branches covered (61.71%)

26957 of 34129 relevant lines covered (78.99%)

0.79 hits per line