kobotoolbox / kpi / 19242097076 / 2

81%

master: 76%

push

github

feat(userReports): add `extra_details` with data related to removing users DEV-1242 (#6453)

### 👀 Preview steps

1. ℹ️ have a superuser account and several other user accounts with
various subscriptions and projects
2. Unapply the user_reports migrations: `./manage.py migrate
user_reports zero`
3. Re-apply the user_reports migrations to see the changes: `./manage.py
migrate user_reports`
4. Checkout the endpoint: `api/v2/user-reports/
5. 🟢 [on PR] notice that the data has been reformatted with
`extra_details__uid` renamed to `user_uid` and a new json containing the
`extra_details`:
```json
  "user_uid": "ujYVFN74XnDrU27AbWWSnR",
  ...
 "extra_details": {
      "data": {
        "name": "kobo",
        "sector": "",
        "country": "",
        "organization": "",
        "last_ui_language": "en",
        "organization_type": "",
        "organization_website": "",
        "newsletter_subscription": false,
        "done_storage_limits_check": true
      },
      "date_removed": null,
      "validated_password": true,
      "password_date_changed": null,
      "date_removal_requested": "2025-11-07T22:12:55Z"
  },
```
6. 🟢 Test various filters on different fields and ensure that they work
correctly
Some examples:
- `?q=user__uid:myuidstring`
- `?q=extra_details__data__name:myname`
- `?q=extra_details__data__organization:myorg`
- `?q=extra_details__date_removed__isnull:True`
- `?q=extra_details__date_removed__ne:null`
- `?q=extra_details__validated_password:True`
- `?q=extra_details__password_date_changed__isnull:True`
- `?q=extra_details__date_removal_requested:"2025-11-07T22:12:55Z"`

7138 of 11204 branches covered (63.71%)

27377 of 33684 relevant lines covered (81.28%)

0.81 hits per line