You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by "Zayyad A. Said" <za...@intrasofttechnologies.com> on 2017/01/17 14:08:47 UTC
Stretch Parameter -groupId
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: <ma...@intrasofttechnologies.com>
zayyad@intrasofttechnologies.com
Email banner
Re: Stretch Parameter -groupId
Posted by Sampath Kumar G <sa...@confluxtechnologies.com>.
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: support@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 <
zayyad@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: zayyad@intrasofttechnologies.com
>
>
>
> [image: Email banner]
>
>
>
> *From:* Sampath Kumar G [mailto:sampath@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: zayyad@intrasofttechnologies.com
>
>
>
> [image: Email banner]
>
>
>
> *From:* Sampath Kumar G [mailto:sampath@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: support@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 <
> zayyad@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: zayyad@intrasofttechnologies.com
>
>
>
>
>
>
>
RE: Stretch Parameter -groupId
Posted by "Zayyad A. Said" <za...@intrasofttechnologies.com>.
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: zayyad@intrasofttechnologies.com
Email banner
From: Sampath Kumar G [mailto:sampath@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" <za...@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: zayyad@intrasofttechnologies.com
Email banner
From: Sampath Kumar G [mailto:sampath@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
<http://www.confluxtechnologies.com/> Conflux Technologies Pvt Ltd
#304, 2nd Floor, 7th Main Road
HRBR Layout 1st Block
Bengaluru, Karnataka, 560043 INDIA
<https://docs.google.com/uc?export=download&id=0B3eLG3rDPEV8T0tGSk9sNzRDUzg&revid=0B3eLG3rDPEV8YVF2d1MrdGw1ZEVabWZiWXU2WUdyVnZVSjRnPQ>
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: <ma...@confluxtechnologies.com> support@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 <za...@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: zayyad@intrasofttechnologies.com
RE: Stretch Parameter -groupId
Posted by Sampath Kumar G <sa...@confluxtechnologies.com>.
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" <za...@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: zayyad@intrasofttechnologies.com
>
>
>
> [image: Email banner]
>
>
>
> *From:* Sampath Kumar G [mailto:sampath@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: support@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 <
> zayyad@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: zayyad@intrasofttechnologies.com
>
>
>
>
>
>
>
RE: Stretch Parameter -groupId
Posted by "Zayyad A. Said" <za...@intrasofttechnologies.com>.
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: zayyad@intrasofttechnologies.com
Email banner
From: Sampath Kumar G [mailto:sampath@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
<http://www.confluxtechnologies.com/> Conflux Technologies Pvt Ltd
#304, 2nd Floor, 7th Main Road
HRBR Layout 1st Block
Bengaluru, Karnataka, 560043 INDIA
<https://docs.google.com/uc?export=download&id=0B3eLG3rDPEV8T0tGSk9sNzRDUzg&revid=0B3eLG3rDPEV8YVF2d1MrdGw1ZEVabWZiWXU2WUdyVnZVSjRnPQ>
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: <ma...@confluxtechnologies.com> support@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 <za...@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: zayyad@intrasofttechnologies.com
Re: Stretch Parameter -groupId
Posted by Sampath Kumar G <sa...@confluxtechnologies.com>.
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: support@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 <
zayyad@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: zayyad@intrasofttechnologies.com
>
>
>
> [image: Email banner]
>
>
>