fineract-provider/src/main/resources/sql/migrations/core_db/V256__Update script for General_Ledger_report.sql

update stretchy_report_parameter 
set report_parameter_name='account'
where report_id = (select stretchy_report.id from stretchy_report where report_name='GeneralLedgerReport')
and parameter_id=(select p.id from stretchy_parameter p where parameter_name='SelectGLAccountNO');


update stretchy_report_parameter
set report_parameter_name='fromDate'
where report_id =(select stretchy_report.id from stretchy_report where report_name='GeneralLedgerReport')
and parameter_id=(select p.id from stretchy_parameter p where parameter_name='startDateSelect');

update stretchy_report_parameter
set report_parameter_name='toDate'
where report_id=(select stretchy_report.id from stretchy_report where report_name='GeneralLedgerReport')
and parameter_id=(select p.id from stretchy_parameter p where parameter_name='endDateSelect');

update stretchy_report_parameter
set report_parameter_name='branch'
where report_id=(select stretchy_report.id from stretchy_report where report_name='GeneralLedgerReport')
and parameter_id=(select p.id from stretchy_parameter p where parameter_name='OfficeIdSelectOne');

INSERT INTO `m_permission` (
`grouping` ,
`code` ,
`entity_name` ,
`action_name` ,
`can_maker_checker`
) VALUES ('report', 'READ_General Ledger Report', 'General Ledger Report', 'READ', 0);

update `stretchy_parameter` 
set `parameter_sql` = 'select id aid,name aname\r\nfrom acc_gl_account'
where stretchy_parameter.parameter_name='SelectGLAccountNO';