#2741 - Ministry Filter Search Programs and Offerings [Fix Expired Programs Sort Issue]

[sh16011993]

As a part of this PR, the query to retrieve the list of programs was updated to ensure that the sort order of the retrieved list of programs has the correct order where the inactive programs comprise the programs that have isActive = false or the ones that have the effectiveEndDate <= CURRENT_DATE

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud

[github-actions[bot]]

Backend Unit Tests Coverage Report

Totals
Statements:	22.3% ( 3709 / 16632 )
Methods:	10.38% ( 214 / 2062 )
Lines:	25.64% ( 3217 / 12545 )
Branches:	13.73% ( 278 / 2025 )

[github-actions[bot]]

E2E Workflow Workers Coverage Report

Totals
Statements:	65.43% ( 583 / 891 )
Methods:	59.26% ( 64 / 108 )
Lines:	68.54% ( 464 / 677 )
Branches:	51.89% ( 55 / 106 )

[github-actions[bot]]

E2E Queue Consumers Coverage Report

Totals
Statements:	86.92% ( 1243 / 1430 )
Methods:	88.57% ( 124 / 140 )
Lines:	87.77% ( 1055 / 1202 )
Branches:	72.73% ( 64 / 88 )

[github-actions[bot]]

E2E SIMS API Coverage Report

Totals
Statements:	66.46% ( 5644 / 8492 )
Methods:	63.93% ( 693 / 1084 )
Lines:	70.48% ( 4446 / 6308 )
Branches:	45.91% ( 505 / 1100 )