Marathon Match created in Direct shows up in the Active matches, even if the Status is Draft

[RiteshTC]

A Marathon Match created in Direct. The status is set to Draft.
https://www.topcoder.com/direct/projectOverview.action?formData.projectId=18893
The match start date is set in past.

The match is shown in active marathon matches in the Contest Page
https://community.topcoder.com/longcontest/?m%20odule=ViewProblemStatement

The contest date has been temporarily set in future to avoid the issue for now.

@ajefts @skyhit

[ajefts]

cc: @cwdcwd

@skyhit Do we need to set the round status and/or round_segment dates in a better way?

[skyhit]

@RiteshTC @ajefts @cwdcwd
is the match created with past start date, and a future end date?

[RiteshTC]

It was created with future start and end date. It was created sometime in Sep. Oct 4th was set the Match Start Date

[skyhit]

@RiteshTC @ajefts @cwdcwd
so there is the situation, for active mms, it is just based on the start date and end date, see https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_active_contests.txt

probably, we should do

1. When creating from direct app, it should set a non-active status
2. improve the query to only include active status