kobotoolbox / kpi / 23002712955 / 9

81%

master: 76%

push

github

feat(qual): add verification and source to data views (#6800)

### 📣 Summary
Add 'verification' and 'source' columns for QA questions in data views.


### 📖 Description
For every QA question, add columns indicating whether the response (if
present) is verified or not and whether it was generated manually or
automatically. These columns will appear in exports but not the table
view.


### 💭 Notes
Having the columns show up in exports but not the table is not ideal
behavior, but this way frontend can work off main and we don't have to
combine the frontend and backend changes into one branch or add extra
complexity to gate the feature on the backend, which we don't generally
do. This has been approved by product.


### 👀 Preview steps


1. ℹ️ have an account and a project with an audio question and at least
one submission
2. Add a transcript
3. Add a QA question
4. Add a response (manual) to the question
5. Export data
6. 🟢 [on PR] The export should contain 2 columns after the QA question
column, `<survey_question> - <qa question> - source` and
`<survey_question> - <qa question> - source`. `verified` should be
`False`, `source` should be `manual` for the edited submission.
7. Use AI to generate a new response to the question (you will need to
add `?ff_autoQAEnabled=true` to the url)
8. Export data
9. The `source` column for the edited submission should now say
`generated with AI`. `verified` should still be `False`.
10. Verify the data by PATCHing the `/supplement` endpoint with 
```
{
  "_version": "20250820",
  "{question_xpath}": {
    "automatic_bedrock_qual": {
       "uuid": "{qa question uuid}",
       "verified": true
     }
  }
}
```
11. Export the data
12. 🟢 `verified` should now be True

4579 of 11558 branches covered (39.62%)

21664 of 35223 relevant lines covered (61.51%)

0.62 hits per line