Waiver filtering update [Production]

[AleksandrMolchagin]

Fix for #298.

Please do not merge until debug+Sandbox has been verified.

---

• Changes Implemented:

  1. Fix "ValidFrom" and "ValidTo": Ensure that "ValidFrom" and "ValidTo" fields are corrected, as they were previously swapped.
  2. Move Archive Filtering: Move the filtering based on the Archive status from the server logic to the SOQL query itself.
  3. Add Filtering Condition: Add a condition Waiver_Active_End__c >= TODAY in the SOQL query to filter out waivers that haven't met the required timelines.
  4. Handle Missing Waivers: If no waiver is found, return a 404 HTTP status code with the message: "No current waiver found".

• Examples:

  • Successful Call:

• No Waivers Found: