Topcoder - Implement Registrants tab For Marathon Match Challenges In Direct App

Register
Submit a solution
The challenge is finished.

Challenge Overview

Currently in Topcoder Direct, Besides Marathon Match Challenge type, the Registrants tab is working properly.



For this challenge, we'd like to make the Registrants tab working the same as other challenge types for Marathon Match.

1. If the challenge has `Marathon Match Type` property (project_info_type_id=87), querying the registrants, the same as other challenge type, you probabily can reuse the existing functionality.
2. If the challenge has `Marathon Match Type` property, but the registrants list is empty, retry step 3
3. If the challenge has `Marathon Match Contest Id` property (project_info_type_id=86), querying the needed information of registrants from informixoltp:round_registration
4. If the challenge has `Marathon Match Id` property (project_info_type_id=56), this is the round id, so querying the registrants from informixoltp:round_registration 
5. For Ratings, please use the Marathon Match Ratings purposely
6. For Submission Date, one registrant can have 0 or more than 1 submissions, please use the latest submission date for displaying.
7. Reference queries you can learn from 
https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_all_submissions.txt
https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_coder_submissions_info.txt

Local Setup

- Please follow Build and Run with Docker compose to run the direct app locally


 

Final Submission Guidelines

- Code Changes
- Verification Steps (please directly use queries to change the state of the challenges, so you can test these different cases)

ELIGIBLE EVENTS:

2018 Topcoder(R) Open

Review style

Final Review

Community Review Board

Approval

User Sign-Off

ID: 30061818