How use Javascript to get Interactive Report Sort Order in Oracle Apex
Does anyone know if there is a way in Oracle Apex 22.1 to get an Interactive Report's sort order using javascript?
Instead of the native download action, We are using BI Publisher to download our reports. I need to know how the user have sorted the report on the screen so I can apply the same sort in Excel.
I have not found anything in the APEX javascript APIs that does this.
Solution
Look for the "aria-sort" attribute in the column header. Note that you have the give each column a static id in the interactive report definition > column > Advanced setting. In the screenshot below I only gave the "JOB" column a static id - the other columns have generated ids that are not usable for your case.
- Alternatives for IN and NVL operators for classic report query
- Oracle APEX - Create 'Duplicate' Button Next to the Report
- How can I close the second modal dialog and automatically return to the first modal dialog without reloading the entire page?
- Adding a Toggle to an Interactive Grid Toolbar
- Return Back to the Page which current page called From
- ORA-00001: unique constraint (WKSP_MYSCHEMA.SYS_C00165018598) violated
- Oracle APEX Select Many page item with a Query for a bar chart
- Can an APEX database be extracted from so it can be edited/cleaned and uploaded so it overwrites the old data?
- Oracle Apex - Display Item as a Percentage
- How to dynamically display static text region in Oracle APEX based on whether currently selected person has an active pending request?
- Oracle APEX: allow additional values in the select list
- Oracle Apex AnyChart... if then statement in the XML? Is it possible
- How to remove the slash and get output as mentioned from the date in oracle apex sql
- Oracle APEX Show Custom Alert Message Using Page Item Value
- Oracle Apex Populate read only field based on another field
- How use Javascript to get Interactive Report Sort Order in Oracle Apex
- How to redirect to another url using : owa_util.redirect_url?
- Oracle APex Add custom grid reset button to revert any data changes
- Call a modal window from a dynamic action on change select list
- APEX Oracle multiple messages using g_notification in the same page are overlayed
- How do I create a classic report with no column headers
- jQuery to call on modal page in Apex Oracle verison
- How can I set the value for interactive grid columns before insert dynamic?
- Hand symbol now showing on Dynamic button icon upon hover
- Redirect to another page after downloading PDF file from REST api in Oracle Apex
- Apex Oracle: multi-column popup lov
- Oracle Apex tree child node returning multiple times
- Oracle Apex How to use date column in item filters
- Oracle Apex Clob display column throwing error for null value
- Oracle Apex REST response - PDF File not returning correctly