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!

Passing parameter value to Classic Report

MARK W HENRYApr 21 2022

Using a SQL query from LOV for one column named TERMS.
I have a Page Item that references TERMS properly as a "Select List",
and when run, I get the expected result.
In a region I have a Classic Report, which I query the DB and use ":TERMS", and
I get no rows returned. If I replace :TERMS with the proper term in the classic report query, it runs fine.
How do I pass the LOV to the Classic Report?
Thanks

This post has been answered by Hamza Al-abbasi on Apr 21 2022
Jump to Answer
Comments
Post Details
Added on Apr 21 2022
2 comments
1,065 views