Re: [Mifos-users] ORDER BY Clause not considered in Report Query

Thanks again but this also doesn't work. The results are not ordered. On Thu, 22 Sept 2022, 09:41 JOSE ALBERTO HERNANDEZ MALDONADO, < jose.hernan...@fintecheando.mx> wrote: > Please try the order by > > order by DATE(agje.entry_date) > > > Sent from my iPhone > > On 22 Sep 2022, at 1:18, Kigred

Re: [Mifos-users] ORDER BY Clause not considered in Report Query

Thanks JOSE, but this has also not worked. Like I said in the previous email, the same query works as expected when run directly against the same database (NOT through Fineract's report module) and the results are ordered by date, it is only when I run it through the Fineract Reporting API that

ORDER BY Clause not considered in Report Query

Good Morning Devs, I am creating a (TABLE) report with the following query: SELECT DATE(agje.entry_date) as date, aga.name as 'Account', agje.amount as 'Amount' , mpd.receipt_number as 'Receipt', CASE WHEN msat.transaction_type_enum=1 THEN 'Savings Deposit' WHEN msat.transaction_type_enum =2