Hi Team,

We are facing an issue in excel download - sorting. We have a FOEX grid (source type : "PL/SQL Function Body returning SQL Query") region in our page, in which we ordering the data in ascending order and trying to export the data in excel format. In the exported excel the data are arranged in descending order. This issue is only when setting the source type of the region as PL/SQL Function Body returning SQL Query.

The issue is replicated in DEMO instance. Please refer the below link. On right click of the grid, 'Export' option will be available.


Thanks in advance

Regards, Priya

asked 21 Jul, 08:06

Priya's gravatar image

accept rate: 33%

You are calling the built-in export of the sub report which is handled by APEX, not FOEX.

We would suggest that to properly control the sorting you disable sorting in the report and put the sort in the outer most part of your query.


answered 23 Jul, 03:44

FOEX-SUPPORT's gravatar image

accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 21 Jul, 08:06

Seen: 119 times

Last updated: 23 Jul, 03:44

FOEX Links