Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to Excel

user10991018Oct 27 2021

we upgraded our apex version from Application Express 4.0.0.00.46
to Application Express 20.2.0.00.20
i have a button in my apex page which is used to export data to excel when clicked.
Action - Redirect to URL
Target - Server name -
http://<servername>:<portnumber>/apex/f?p=&APP_ID.:1:&SESSION.:CSV:
i am getting error and not redirecting to csv file.
this code was working in Apex Application Express 4.0.0.00.46

Comments

Mike Kutz

TAG using JSON value might be more flexible.

This would then allow template based code generators (eg ) to automatically identify which tables need to be combined together to create a specific Transactional API (XAPI).  (eg an API that must work with >1 tables)

MK

1 person found this helpful
Jeffrey Kemp

Tags for table columns, constraints, etc. would also be useful.

1 person found this helpful
Matheus Boesing

TAG using JSON value might be more flexible.

This would then allow template based code generators (eg ) to automatically identify which tables need to be combined together to create a specific Transactional API (XAPI).  (eg an API that must work with >1 tables)

MK

Great Mike!
It really should be done with JSON syntax. It allows to create different kinds of tags in a single 'tag column', like:
[...]TAGS ('{Use:Transactional, SensitiveData:false, Version1.0:MatheusDBA, Version2.0:AnotherDBA}');


Or even tags hierarchies/subtypes... Anyway, it's way more flexible.
Thanks for this insight!

Matheus Boesing

Tags for table columns, constraints, etc. would also be useful.

Exactly... I just used some kind of objects for this example... but I believe it can apply for any king of object, including schemas... like (using Mike's contribution):
CREATE USER USER_EXAMPLE TAGS ('{Use:AdHocReports, Accountable:InternalBusinessTeam}');

Gbenga Ajakaye

This would definitely be useful.

1 - 5

Post Details

Added on Oct 27 2021
#apex-discussions
2 comments
111 views