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.

Apex interactive report with mandatory filter

aitchbee2000Mar 9 2016 — edited Mar 9 2016

I'm new to Apex, so would appreciate some advice.  We are using Apex 5 on Oracle 12c.

I have developed an interactive report against a table which contains 650 million rows.  I would like to ensure that the user enters some sort of filter on the report, since attempting to run an unfiltered report will inevitable cause a crash due to the sheer volume of data returned.

Is there some way I can check that the user has set at least one filter on the report before running it, giving them an error message if they haven't?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2016
Added on Mar 9 2016
10 comments
2,077 views