glebovpavel / IR_to_MSExcel

Oracle Apex plugin for Interactive Grid or Interactive Report
http://glebovpavel.github.io/Description_IR_TO_XSLX/
Other
39 stars 14 forks source link

Fails in Apex 5 with multiple interactive reports on page #10

Closed HeavyS closed 8 years ago

HeavyS commented 8 years ago

In all queries about selecting IR properties should be region_id, report_id or interactive_report_id May be as additional input parameter of IR: region_static_id, region_id, IR id. Changes should be in ir_to_msexcel.get_xlsx_from_ir_ext xml_to_xslx.download_file xml_to_xslx.get_max_rows xml_to_xslx.get_file_name ir_to_xml.get_report_xml (both) ir_to_xml.init_t_report

And one more issue next to multiple IR is that column names in apex 5 in browser now like 'C5934384274029800' (column id, not db_column_name), that's why custom column ignores.Temporary fix is to set static ids for each column, but it is boring) I think there should be transformation from id to db_column_name, for example in xml_to_xslx.get_colls_width_xml

Sorry for such detailed recommedations, but I hope it will be helpful.