AshharAhmadKhan opened a new pull request, #5754: URL: https://github.com/apache/fineract/pull/5754
## Description The ClientTrendsByWeek, ClientTrendsByMonth, LoanTrendsByWeek, and LoanTrendsByMonth reports were using MySQL-specific functions (WEEK(), MONTHNAME()) that don't exist in PostgreSQL, causing a BadSqlGrammarException when running on a PostgreSQL database. This replaces those functions with ISO-standard equivalents — EXTRACT(WEEK FROM ...) and TO_CHAR(..., 'Month') — which work correctly on both MySQL and PostgreSQL. Picks up from #5477 (closed as abandoned), extends the fix to cover all 4 affected reports and adds an integration test for each. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
