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!

Newbie Question: why does the where clause seem to get ignored

New to Apex: finding the whole experience a little frustrating.

Working on an Apex instance from an OCI ADW Cloud Database (Oracle APEX 24.2.6).

I have built a report with an included form. Form/Report based on a local table. Trying to filter the initial fetch with a where clause, and cannot get it to work. The where clause seems to get ignored.

Simple question: if i add a where clause of “1=2” in the where clause property in the source properties, how can the report still fetch data back?

This post has been answered by InoL on Aug 6 2025
Jump to Answer
Comments
Post Details
Added on Aug 6 2025
6 comments
125 views