I'm submitting a ...

• improvement request (usability, performance, tech debt, etc.)

Traffic Control components affected ...

• Traffic Ops
• Traffic Ops ORT

Current behavior:

The Traffic Ops GET /api/x/jobs API currently returns all invalidation jobs ever created. For applications like ORT that really only need to get unexpired invalidation jobs, this is very inefficient.

New behavior:

Provide a query parameter option to return only invalidation jobs created within the maxRevalDurationDays window. Update ORT to use the new query parameter option. For performance reasons, we might want to add a DB index on the start_time column w/ DESC NULLS LAST, similar to the last_updated index.

Minimal reproduction of the problem with instructions:

Request the TO GET /api/x/jobs route, observe that every job ever created is returned.