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]] 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 <http://www.sungard.com/> From: Trilok J. Pandya [mailto:[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
<<image001.jpg>>
------------------------------------------------------------------------------ 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
