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
