[Aperture] Decisions containing blank comment fields
Looking through a recent data dump from Aperture-neuro, I found the following manuscripts with decisions in which the comment (a required field) was blank:
short_id | id | json_data->'comment'
----------+--------------------------------------+----------------------------
79 | e130fcd2-ce83-4222-856d-c82022013a50 | <p class="paragraph"> </p>
76 | 1cdce19c-e6db-4684-97cb-ae709da06a3f | <p class="paragraph"> </p>
57 | 987307f0-2f29-40f8-9c9d-350921b9005e | <p class="paragraph"> </p>
56 | f676948b-c1a8-467d-8e4b-50fd796da7d1 | <p class="paragraph"> </p>
55 | 403c3640-5f89-434b-bf0d-6a999ea593d1 | <p class="paragraph"> </p>
55 | 403c3640-5f89-434b-bf0d-6a999ea593d1 | <p class="paragraph"> </p>
52 | 82179f90-eeb9-4933-adbe-c2a454577289 | <p class="paragraph"></p>
51 | 2e69f7cc-f061-40ad-ad77-017110464dfd | <p class="paragraph"></p>
49 | 0b464d35-41d5-406a-9f06-9b95875ccf9c | <p class="paragraph"></p>
46 | 2e179dbf-5e37-4338-a639-9ceb92b055ea | <p class="paragraph"></p>
45 | 0af05fd2-3ae7-4931-a52d-d336d994f0b5 | <p class="paragraph"></p>
42 | 31bb5b68-2184-411b-8c00-a1dacb61e1da | <p class="paragraph"></p>
39 | 6727e860-95c1-445c-a47a-177d9e699d46 | <p class="paragraph"></p>
38 | 8944e106-c54b-40d7-a620-925f7b074f99 | <p class="paragraph"> </p>
38 | 8944e106-c54b-40d7-a620-925f7b074f99 | <p class="paragraph"></p>
36 | 0cb8722c-79c1-47ae-bea6-74492fb270f3 | <p class="paragraph"></p>
33 | c2dcb209-e196-4611-bdfe-5ede2ace5329 | null
32 | 013c1ec5-4f92-4b3f-bd99-6bad8a30dd20 | <p class="paragraph"> </p>
25 | e6198273-b8e3-4b63-babb-6e6b0da10669 | <p class="paragraph"> </p>
- In some of these, it appears the user has circumvented the 'required field' validation by entering a single space. We should prevent them doing this by detecting that there's whitespace only.
- In others, there is just an empty paragraph, which validation is already supposed to prevent. How did these get through? None of these are very recent.
- In manuscript 33 (latest version) there is a decision containing no comment at all. The JSON is
{"verdict": "accept"}
, which is very unusual. We would normally expect something like{"files": null, "comment": "<p class=\"paragraph\">blah blah</p>", "verdict": "accept"}
. - Note there are two manuscript records (38 and 55) containing more than one decision for the same manuscript version. This bug is separately logged as #1195.