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!

Oracle Apex Rest Data Source- Filter Data based on Date parameter

Parul_ORANov 19 2024 — edited Nov 19 2024

Hi Apex team,

I am using Oracle Apex cloud v24.1 and created an Oracle Fusion rest data source with rest synchronization.

I have a requirement to filter Rest Api response based on this condition:
TRUNC(sysdate) between TRUNC(NVL(StartDateActive, TO_DATE('1900-01-01', 'YYYY-MM-DD'))) AND TRUNC(NVL(EndDateActive, TO_DATE('9999-12-31', 'YYYY-MM-DD'))

In the rest data source profile I have only 2 columns: StartDateActive and EndDateActive.

Can you please say, is it achievable ? and how to add these in query parameter ?

Thanks in advance..!!

Added on Nov 19 2024

#apex, #apex-discussions, #apex-web-service, #apex20-2, #apex23-2, #oracle-apex

0 comments

679 views