Hi Zayyad, I have modified the previous script, you can use the below one.
INSERT INTO `stretchy_parameter` (`parameter_name`, `parameter_variable`, `parameter_label`, `parameter_displayType`, `parameter_FormatType`, `parameter_default`, `special`, `selectOne`, `selectAll`, `parameter_sql`, `parent_id`) VALUES ('GroupnameDependOnStaff', 'groupId', 'Group Name', 'select', 'number', '0', NULL, 'Y', NULL, 'SELECT mg.id id, mg.display_name name FROM m_group mg WHERE mg.level_id = 2 AND mg.status_enum =300 AND mg.staff_id = ${loanOfficerId}', (SELECT sp.id from stretchy_parameter sp where sp.parameter_name = 'loanOfficerIdSelectAll')); Thanks and regards, Sampath *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> * #304, 2nd Floor, 7th Main Road HRBR Layout 1st Block Bengaluru, Karnataka, 560043 INDIA Disclaimer: The information contained in this e-mail message and any files/attachment transmitted with it is confidential and for the sole use of the intended recipient(s) or entity identified. If you are not the intended recipient, please email: supp...@confluxtechnologies.com and destroy/delete all copies and attachment thereto along with the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and is unlawful. The recipient acknowledges that Conflux Technologies Private Limited or its subsidiaries and associated companies are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions. Before opening any attachments, please check. On Wed, Jan 18, 2017 at 11:57 PM, Zayyad A. Said < zay...@intrasofttechnologies.com> wrote: > Hi Sampath, > > > > Having executed the script it inserted the field of groupId in > stretchy_parameter table, however I noticed that when you select Loan > Officer it populates all groups of the organization instead of filtering > only the groups handled by that particular officer. > > > > Is there a way we could modify this script to be filtering the groups as > is the behaviour with Loan Officer when you select an Office? > > > > On the same note, kindly also assist with a script I can populate data for > groups within a center. > > > > Kindly advise. > > > > Thanks, > > > > > > ********* > > *Zayyad A. Said | Chairman & C.E.O* > > > > Cell No.: +254 716 615274 | Skype: *zsaid2011* > > Email: zay...@intrasofttechnologies.com > > > > [image: Email banner] > > > > *From:* Sampath Kumar G [mailto:samp...@confluxtechnologies.com] > *Sent:* 18 January 2017 20:41 > *To:* Zayyad A. Said > *Cc:* Mifos software development; dev@fineract.incubator.apache.org > *Subject:* RE: Stretch Parameter -groupId > > > > Zayyad, > > > > The file is attached to that mail. I dnt no why you can't find it. > > Anyhow, I have pasted the same here. Let me know if any issue. > > > > > > INSERT INTO `stretchy_parameter` (`parameter_name`, `parameter_variable`, > `parameter_label`, `parameter_displayType`, `parameter_FormatType`, > `parameter_default`, `special`, `selectOne`, `selectAll`, `parameter_sql`, > `parent_id`) VALUES ('Group name', 'groupId', 'groupId', 'select', > 'number', '0', NULL, 'Y', NULL, 'SELECT mg.id id, mg.display_name name > FROM m_group mg WHERE mg.level_id = 2 AND mg.status_enum =300', NULL); > > > > On Jan 18, 2017 10:05 PM, "Zayyad A. Said" <zayyad@intrasofttechnologies. > com> wrote: > > Hi Sampath, > > > > No attachment was in your email, kindly resend. > > > > Regards; > > > > > > ********* > > *Zayyad A. Said | Chairman & C.E.O* > > > > Cell No.: +254 716 615274 | Skype: *zsaid2011* > > Email: zay...@intrasofttechnologies.com > > > > [image: Email banner] > > > > *From:* Sampath Kumar G [mailto:samp...@confluxtechnologies.com] > *Sent:* 18 January 2017 08:04 > *To:* dev@fineract.incubator.apache.org > *Cc:* Mifos software development > *Subject:* Re: Stretch Parameter -groupId > > > > Hi Zayyad, > > > > Please find the attachment, insert script for the group as a parameter. > > > Thanks and regards, > > Sampath > > > > > > > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> * > > #304, 2nd Floor, 7th Main Road > > HRBR Layout 1st Block > > Bengaluru, Karnataka, 560043 INDIA > > > > Disclaimer: The information contained in this e-mail message and any > files/attachment transmitted with it is confidential and for the sole use > of the intended recipient(s) or entity identified. If you are not the > intended recipient, please email: supp...@confluxtechnologies.com and > destroy/delete all copies and attachment thereto along with the original > message. Any unauthorised review, use, disclosure, dissemination, > forwarding, printing or copying of this email or any action taken in > reliance on this e-mail is strictly prohibited and is unlawful. The > recipient acknowledges that Conflux Technologies Private Limited or its > subsidiaries and associated companies are unable to exercise control or > ensure or guarantee the integrity of/over the contents of the information > contained in e-mail transmissions. Before opening any attachments, please > check. > > > > On Tue, Jan 17, 2017 at 7:38 PM, Zayyad A. Said < > zay...@intrasofttechnologies.com> wrote: > > Devs, > > > > I am trying to develop a report which contains groups. > > > > I need to set Group as parameter to pass to Pentaho as we need report per > group. > > > > I don’t see groupId in the table stretchy_parameter, how then can I use > Group as parameter in my report? > > > > Kindly but urgently advise on this. > > > > Thanks & Regards; > > > > > > ********* > > *Zayyad A. Said | Chairman & C.E.O* > > > > Cell No.: +254 716 615274 | Skype: *zsaid2011* > > Email: zay...@intrasofttechnologies.com > > > > > > >