Jessica,
Have you look at the demo reports from the BI product?
http://mifos.org/functional-specifications/pentaho-reports-in-mifos
These might resolve a lot of your requests below
We also have this -
http://mifosforge.jira.com/wiki/display/MIFOS/SQL+Query+Repository
Ryan
On 3/27/11 10:29 PM
lue.lookup_id
where center.customer_id=?
and grp.customer_id=?
group by lookup_value.lookup_name
Thanks,
Ramya
From: Jessica Cheng [mailto:jessica.chen...@gmail.com]
Sent: Monday, March 28, 2011 10:59 AM
To: A good place to start for users or folks new to Mifos.
Subject: [Mifos-users] R
Jessica
,
i have create one query for your following
7. List of loans based on its funding source
SELECT
(select d.display_name from office d where
d.office_id=c.branch_id) as $Branch_Name,
BigBoss.display_name as
Hi all,
We are looking for SQL statements for the following queries; they will give
us a great head start on customizing reports.
Anything you have in producing the following will help:
1. List future disbursement on a given future time
2. List collected cash on a past given date
3. List of actu
