Hi Sifiso, I was saw the query which is shared by you., I think Query don't have any errors., I was moved to another company.Now I dont have mifos env. Mifos has custom report option ., you have run the query in your Report panel. I think that works fine.First of all I dont have knowledge about middleware program.I'm a database developer.
Thanks, Ramesh On Mon, Jun 25, 2018 at 4:05 PM, <[email protected]> wrote: > Noted Ramesh, > > > > Let me check your query now. Meanwhile please check the standard reports > that I have made changes to above. Does it run on your environment. I think > we’re having a driver compatibility challenge because those changes don’t > seem to run in Mifos. > > > > Kind regards, > > Sifiso > > > > > > > > *From:* Ramesh Ram <[email protected]> > *Sent:* Monday, June 25, 2018 9:11 AM > *To:* A good place to start for users or folks new to Mifos. < > [email protected]> > > *Subject:* Re: [Mifos-users] hi , i have created the DayBook report, > Active clients on date report and also Demand sheet for for JLG loans . > > > > This should be work.. > > please exclude the commented lines.., (start with --).., > > > > > > > > > > select > > --od.name as 'Office', > > s.display_name as CRO, > > m.display_name as "group_name", > > -- m.id as "group_id", > > count(DISTINCT l.client_id) as 'Clients', > > -- count(DISTINCT l.id) as 'loan_id', > > (CASE WHEN SUBSTRING(recurrence,-2)='SU' then 'Sunday' when > SUBSTRING(recurrence,-2)='MO' then 'Monday' WHEN > SUBSTRING(recurrence,-2)='TU' then 'Tuesday' when > SUBSTRING(recurrence,-2)='WE' then 'Wednesday' > > when SUBSTRING(recurrence,-2)='TH' then 'Thursday' WHEN > SUBSTRING(recurrence,-2)='FR' then 'Friday' when > SUBSTRING(recurrence,-2)='SA' then 'Saturday' end) as Day > > > > -- l.disbursedon_date, > > --gl.LatLong, > > --concat (gl.Address,',',gl.Landmark) as 'Meeting Place', > > --cv.`code_value` as 'Time' > > from m_group m > > inner join m_loan l on l.group_id=m.id > > -- LEFT JOIN (select office_id,id,name from OFFICE_LIST where > id=${officeId}) od on od.office_id=m.office_id > > -- LEFT JOIN GroupLocation gl ON gl.group_id=m.id > > -- LEFT JOIN MeetingTime on mt.group_id=m.id and > l.disbursedon_date=mt.Date > > -- LEFT JOIN m_code_value ON cv.id=mt.MeetingTime_cd_Time > > INNER JOIN (select a.id as 'group_id',a.parent_id from m_group a where > a.parent_id is not null)b ON b.group_id=m.id > > LEFT JOIN m_calendar_instance ci on ci.entity_id=b.parent_id and > entity_type_enum=4 > > INNER JOIN m_calendar mc on mc.id=ci.calendar_id > > LEFT JOIN m_staff s on s.id=m.staff_id > > where ((l.expected_maturedon_date>'2018-02-10') or (l.closedon_date > >'2018-02-10') or > >'2018-02-10'<ifnull(l.closedon_date,adddate('2018-02-10',+1))) > and (l.disbursedon_date<='2018-02-10') and (l.loan_status_id=300 or > '2018-02-10'<ifnull(l.closedon_date,adddate('2018-02-10',+1))) > > group by m.id > > > > On Sat, Jun 23, 2018 at 1:48 PM, <[email protected]> wrote: > > Hi Santosh, > > > > I have noticed that the select concat queries that run in stretchy reports > and pentaho do not run in the database directly. They produce errors there. > All the queries in the pentaho reports in Mifos perform the same way. > > > > I have a simulation attached for active client loans as at a date report > that you can test attached for inclusion into fineract. > > > > I have more if you would like to test and include, if you’re interested. > > > > Kind regards, > > > > Sifiso > > > > > > *From:* Santosh Math <[email protected]> > *Sent:* Saturday, June 23, 2018 2:49 AM > *To:* mifos-users <[email protected]> > *Cc:* Mifos software development <[email protected]>; > Dev <[email protected]> > *Subject:* Re: [Mifos-users] hi , i have created the DayBook report, > Active clients on date report and also Demand sheet for for JLG loans . > > > > Hi Ramesh, > > > > Could u share the query which I can run in my database? > > > > Thanks > > Santosh > > > > On Fri 22 Jun, 2018, 11:42 PM Ramesh Ram, <[email protected]> wrote: > > Hi santhosh.., > > > > We have modified the database for our business model. So it didn't run in > demo site.,but you can alter the query for your database.. Some tables > are varried..but rule is same. Kindly you review your database. > > > > Thanks., > > Ramesh > > > > On Fri 22 Jun, 2018, 6:44 PM Santosh Math, <santosh@confluxtechnologies. > com> wrote: > > Hi Ramesh, > > > > I need to test your following reports on https://demo.openmf.org ( I > created stretchy reports with same name). However, after running the > reports , I am not getting any output. > > > > > > 1) Active Query > > 2) Demand Sheet Query > > 3) DailySheet query. > > > > Could you check there? > > > > Thanks > > Santosh > > > > On Fri, Jun 22, 2018 at 12:21 PM, Ramesh Ram <[email protected]> > wrote: > > ok Abiy > > > > On Fri, Jun 22, 2018 at 6:06 AM, Abiy Atsbha <[email protected]> wrote: > > I will skype you Ramesh. > > > > On Fri, Jun 22, 2018 at 9:33 AM Ramesh Ram <[email protected]> > wrote: > > Hi Abiy, > I can't understand this concept., Do you want to create a new report or > Implement the these report., Please elobarate this . > > Thanks, > > Ramesh > > > > On Thu, Jun 21, 2018 at 1:00 PM, Abiy Atsbha <[email protected]> wrote: > > Corrected Mail, > > > > Dear Ramesh, > > > > Hey bro, I am glad you are doing this. > And Since Ed, wants to review this and add it to standard Mifos X report, > I have BROUGHT you sample DAILY TRANSACTION LIST report of T24-Temenos > Banking Software, this report was not shipped with it originally, it was > locally developed. It records all the daily transactions including > Accounts, Funds Transfers, Teller Transactions, Loan, Deposits & Pastdue > Loans. All transactions that have effect on the accounting are recorded > inside this report. > > > I am attaching this report with this mail, so as to help you in designing > the report layout and its inside components. > > Good Luck bro. > > Abiy A. > > > > > > On Thu, Jun 21, 2018 at 11:38 AM Ramesh Ram <[email protected]> > wrote: > > > I am glad to on work with you on this process, please let me know the > timings for our discussions > > Thank you, > Ramesh > > > > On Wed, Jun 20, 2018 at 3:41 AM, Ed Cable <[email protected]> wrote: > > Can we work on reviewing this and potentially adding as another standard > report in Mifos X? > > > Thanks, > > > Ed > > > > On Sat, Jun 16, 2018 at 8:12 PM solomon anaman <[email protected]> > wrote: > > Hello can you please help me with a report on transactions by a cashiers > where each cahiers report will be pulled separately? > > Thank you > > > > On Mon, Apr 30, 2018 at 11:16 AM, Ramesh Ram <[email protected]> > wrote: > > im happy for your reply. please askme if you have any doubts. i also > have code for group find group status which is renewal or new group. > > > > On Mon, Apr 30, 2018 at 6:00 PM, Abiy Atsbha <[email protected]> wrote: > > Dear Ramosh, > > > > That is very helpful. I will use it for my production. > > > > Thanks & Regards, > > Abiy A. > > Ethiotechs Innovative Solutions > > > > On Mon, Apr 30, 2018 at 2:59 PM, Ramesh Ram <[email protected]> > wrote: > > I have use the mifosx application for jlg loans. so these reports are > very help full for daily activities.So i'm sharing these code .if you need > this you will use it. > > > > Thank you. > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot______ > _________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > -- > > *Ed Cable* > > President/CEO, Mifos Initiative > > [email protected] | Skype: edcable | Mobile: +1.484.477.8649 > > > > *Collectively Creating a World of 3 Billion Maries | *http://mifos.org > <http://facebook.com/mifos> <http://www.twitter.com/mifos> > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot______ > _________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot______ > _________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > > -- > > Thanks & Regards > > Santosh Math > > *QA Engineer* > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* > > | *Office*: +91-080-41208662 | > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, > Bengaluru, Karnataka, 560043 INDIA > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot______ > _________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot______ > _________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > ------------------------------ > > [image: Avast logo] <https://www.avast.com/antivirus> > > This email has been checked for viruses by Avast antivirus software. > www.avast.com <https://www.avast.com/antivirus> > > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > >
