BUG - New committed data does not show in 'Retrieve Submitted Data' endpoint

[hknahal]

Description of error

I used the following participant.tsv file.

1. Submitted participant.tsv file to study ID TEST-CA using categoryID 11 using this endpoint: https://submission.pcgl-dev.cumulus.genomeinformatics.org/api-docs/#/Submission/post_submission_category__categoryId__data

2. Using submissionID 366 returning from Step 1, I checked submission to verify it is valid and has no errors using this endpoint: https://submission.pcgl-dev.cumulus.genomeinformatics.org/api-docs/#/Submission/get_submission__submissionId_). This returned VALID.

3. Commited the submission using the https://submission.pcgl-dev.cumulus.genomeinformatics.org/api-docs/#/Submission/post_submission_category__categoryId__commit__submissionId_ endpoint.

4. Verified submitted data was in "COMMITTED" state using https://submission.pcgl-dev.cumulus.genomeinformatics.org/api-docs/#/Submission/get_submission__submissionId_ endpoint:

4. Check the study TEST-CA to see the committed participant data using this endpoint https://submission.pcgl-dev.cumulus.genomeinformatics.org/api-docs/#/Data/get_data_category__categoryId__organization__organization_ using categoryID 11. In my example, I tried searching for submitter_participant_id my_participant_1000 which exists in the original participant.tsv file I submitted. However, it does not exist.

The total number of records has increased though from 5006 to 6006, but the new committed data is not showing:

Steps to reproduce:

Follow the above steps using this participant.tsv file.