Thanks Alberto. This is definitely what I am looking for. Regards Wilfred On Fri, Feb 18, 2022 at 6:11 PM JOSE ALBERTO HERNANDEZ MALDONADO < jose.hernan...@fintecheando.mx> wrote:
> Hello! > > Yes there is a query parameter to filter Loans the sqlSearch > > > /fineract-provider/api/v1/loans?limit=1000&sqlSearch=l.loan_status_id+in+(100) > > or if you need more than one Loan status > > > /fineract-provider/api/v1/loans?limit=1000&sqlSearch=l.loan_status_id+in+(100,200) > > The status code are: > 100: Submitted and Pending Approval, > 200: Approved, > 300: Active (Disbursed) > 301: Overdue > 302: Overdue NPA > 400: Withdrawn by Client > 500: Rejected > 600: Closed Obligations Meet > 700: Closed Overpaid > > Thanks > Alberto > > On Thu, Feb 17, 2022 at 9:47 PM Kigred Developer < > kigred.develo...@gmail.com> wrote: > >> Hello Devs, >> >> Is there a way to specify status when listing loans. I need to query >> loans of different status for example status='Pending Approval'. I am aware >> that I can run a report and get these lists but that alternative cannot fit >> what I am looking for since it requires user input/actions. >> I can see one can specify sqlSearch argument, this is probably what I >> would use but I have not been successful with it so far. Can some help with >> an example? >> >> Regards. >> _______________________________________________ >> Mifos-users mailing list >> Mifos-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
