Hi Sifosio - I am attaching the dev list as well. I was working with another user who was having an issue with the stretchy reports this weekend. It appears that there is an issue with the V345__reports_for_self_service_user.sql migration script, but I haven't had a chance to look at it fully. I am not sure what issue that this migration script was written to fix, but it appears that it is using stretchy_parameters.id instead of strechy_parameters.parameter_id and stretchy_report.id instead of stretchy_report.report_id.
Does someone have a little time to look into this? Thanks, Steve On Mon, Apr 15, 2019 at 7:31 AM <[email protected]> wrote: > It’s called the Stretchy report parameters table > > > > Regards, > > Sifiso > > > > *From:* brahiman yogo [mailto:[email protected]] > *Sent:* Monday, 15 April 2019 1:46 PM > *To:* Mifos software development <[email protected]> > *Subject:* Re: [Mifos-developer] Hello, I have a problem with the > creation of a new report. in fact when I create the report and I execute it > there is no result. Has anyone come across this problem before > > > > What is the report table In thé datatable? > > > > Le lun. 15 avr. 2019 à 11:42, <[email protected]> a écrit : > > You have to add the parameters of your report to the reports table in the > database. > > > > Regards, > > Sifiso > > > > *From:* brahiman yogo [mailto:[email protected]] > *Sent:* Monday, 15 April 2019 11:24 AM > *To:* Mifos software development <[email protected]> > *Subject:* Re: [Mifos-developer] Hello, I have a problem with the > creation of a new report. in fact when I create the report and I execute it > there is no result. Has anyone come across this problem before > > > > When I run out of the software everything works fine > > > > Le lun. 15 avr. 2019 à 08:16, Roshan Ratnaweera <[email protected]> a > écrit : > > The issue is m_client table had not been joined. Please use a query edit > software like MySql workbench, SQLyog to create your query. If it would be > succeed, add parameters and create your table report. > > > > Roshan. > > > > On Mon, Apr 15, 2019 at 1:29 PM brahiman yogo <[email protected]> > wrote: > > SELECT c.id AS "id", > > c.firstname AS "firstName", > > c.middlename AS "middleName", > > c.lastname AS "lastName", > > c.display_name AS "fullName", > > c.mobile_no AS "mobileNo", CONCAT(REPEAT("..", > ((LENGTH(ounder.`hierarchy`) - LENGTH( > > REPLACE(ounder.`hierarchy`, '.', '')) - 1))), ounder.`name`) AS > "officeName", > > o.id AS "officeNumber" > > FROM m_office o > > JOIN m_office ounder ON ounder.hierarchy LIKE CONCAT(o.hierarchy, '%') > > JOIN m_group c ON c.office_id = ounder.id > > LEFT JOIN r_enum_value r ON r.enum_name = 'status_enum' AND r.enum_id = > c.status_enum > > WHERE o.id = ${officeId} AND c.status_enum = 300 AND (IFNULL(c.staff_id, > -10) = ${loanOfficerId} OR "-1" = ${loanOfficerId}) > > GROUP BY c.id > > ORDER BY ounder.hierarchy, c.account_no > > > > here is the script. I just modify the request from the individual customer > list > > > > Le lun. 15 avr. 2019 à 02:59, Roshan Ratnaweera <[email protected]> a > écrit : > > Ok. Could you send that query ? > > > > On Mon, Apr 15, 2019 at 3:59 AM brahiman yogo <[email protected]> > wrote: > > hi actually i have created a report table with a simple query but i do not > get a result > > > > Le dim. 14 avr. 2019 à 07:34, Roshan Ratnaweera <[email protected]> a > écrit : > > hi Brahiman, > > > > Please send your report file > > > > > > Thanks, > > Roshan. > > > > On Sat, Apr 13, 2019 at 5:27 AM brahiman yogo <[email protected]> > wrote: > > > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer
