Trilok,
Are you aware of the Datawarehouse capability being delivered presently for
mifos?
To get accurate result based on historical details you could correctly find
active (or on_hold) clients for a given date doing something like this:
select count(*)
from dim_customer
where customer_status in ('ClientStatus-Active', 'ClientStatus-OnHold')
and valid_from <= '2010-07-10' and valid_to > '2010-07-10'
At present the DW doesn't have Fee details at the moment but if reports were
needed with fee details, this could be easily added i am sure.
Keith.
On Mon, Dec 20, 2010 at 10:51 AM, Trilok J. Pandya <
[email protected]> wrote:
> dear Friends,
>
> i want one more help.
>
> Active Client's on perticular date. i.e. i want list of all clients on
> particular date disbursement amount, according to its loan fee, mem fee and
> insurance fee.
> *select disb_amt, loan_fee, mem_fee, insurance_fee, full path of member
> from ..... where date_field = '2010-12-20'*
>
>
> On 20-12-2010 15:16, Edward Cable wrote:
>
> Trilok,
>
>
>
> I’m glad Ramya was able to help you with your query.
>
>
>
> In the future if you have a request please also document it on the SQL
> Query Request page on MifosForge and then request it on the mailing list as
> well. That way we’ll have one centralized place where common and requested
> SQL queries can be found without having to search around. Hopefully this
> page will become a useful self-support tool for you and others:
>
>
>
> http://mifosforge.jira.com/wiki/display/MIFOS/SQL+Query+Repository
>
>
>
> Ed
>
>
>
> *From:* Trilok J. Pandya
> [mailto:[email protected]<[email protected]>]
>
> *Sent:* Sunday, December 19, 2010 10:02 PM
> *To:* A good place to start for users or folks new to Mifos.
> *Cc:* [email protected]; [email protected]
> *Subject:* Re: [Mifos-users] [Mifos-developer] Want A List Of All Loans
> Which is not Disbursed
>
>
>
> thanks Ramya
>
>
>
> On 20-12-2010 09:49, [email protected] wrote:
>
> Hi Trilok,
>
>
>
> Below is the query fetching up all loan accounts details with their
> customer names. The field ACCOUNT_STATE with value as APPLICATION APPROVED
> is the one whose loan needs to be disbursed.(already approved but pending
> for disbursal)
>
>
>
> select
>
> office.display_name as BRANCH,
>
> center.display_name CENTER,
>
> grp.display_name GROUP_NAME,
>
> client.display_name ClIENT_NAME,
>
> account.global_account_num ACCOUNT_NUM,
>
> account_state.status_description as ACCOUNT_STATE
>
> from
>
> office
>
> inner join customer client on client.branch_id=office.office_id
>
> inner join customer grp on grp.customer_id=client.parent_customer_id
>
> inner join customer center on center.customer_id=grp.parent_customer_id
>
> inner join account on account.customer_id=client.customer_id
>
> inner join loan_account on loan_account.account_id=account.account_id
>
> inner join account_state on
> account_state.account_state_id=account.account_state_id
>
> order by
> office.display_name,center.display_name,grp.display_name,client.display_name,account_state.status_description
>
> Thanks & Regards,
>
> *Ramya Toshniwal* • SunGard Technology Services • Embassy Icon,Infantry
> Road, Bangalore,India
> Tel +91-80-2222-0501 Extn - 3240 www.sungard.com
>
>
>
> *From:* Trilok J. Pandya
> [mailto:[email protected]<[email protected]>]
>
> *Sent:* Saturday, December 18, 2010 3:35 PM
> *To:* Mifos Developer Discussions; [email protected]
> *Subject:* [Mifos-developer] Want A List Of All Loans Which is not
> Disbursed
>
>
>
> dear friend
>
> i want a list of all loans which is still not disbursed with its customer
> details and loan details.
>
> and one more thing that
>
> i have to find the status of loan in this i want by which field we can find
> that this loan is disbursed or not .
>
> --
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> Lotusphere 2011
>
> Register now for Lotusphere 2011 and learn how
>
> to connect the dots, take your collaborative environment
>
> to the next level, and enter the era of Social Business.
>
> http://p.sf.net/sfu/lotusphere-d2d
>
>
>
>
>
> _______________________________________________
>
> Mifos-users mailing list
>
> [email protected]
>
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social
> Business.http://p.sf.net/sfu/lotusphere-d2d
>
>
>
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
>
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
