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!

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
382 views