Hello,
I'm using a local installation of APEX 24.2, which I have set up to invoke other local APIs through ORDs.
I'm having an issue in one of my pages where I invoke one of my REST Data sources through a classic report (custom blank with attributes (no grid) template, with a custom timeline template for my attributes), specifically, the order my records show up in.
I have defined 2 parameters for my REST data source, orderBy and isDesc, which, if they are not specified, are sent as null to my ORDs endpoint - thus using the default parameters I have defined there. This default order is the most recent records first, and it is what I want for my classic report. But this doesn't happen - it shows the oldest records first:
When performing a test operation on my data source, I get the records in the correct order:
Here's the definition for my query parameters:
I have tried ordering the records in a post-processing SQL script, with no success. I have also tried sending the query parameters anyways, which also did not work.
I am very new to Oracle APEX, so there are still details I'm not sure of. Is there a specific order classic reports apply when loading the page? How can I circumvent this issue?
Thank you!