Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to use page items in report queries

jacklessOct 19 2021 — edited Oct 19 2021

Dear Community,
i'm using the shared component "report query" to export data from my application. The sql-query looks sth like this:

select * from my_table where year >= :P1_START_YEAR AND year <= :P1_END_YEAR

The problem is that my page items aren't working in report query. If I'm using a static number instead if my page items the query is working and i get a correct export. Apex is suggesting to use bind variables but i couldn't figure out a way to use them.
Thanks for the help!

Comments

Post Details

Added on Oct 19 2021
3 comments
381 views