My Oracle Support Banner

How to submit a query which refers a text item in the where-clause by hitting "Go" in an Interactive Report (Doc ID 1496506.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 4.1.1 and later
Information in this document applies to any platform.


When adding a text field, separate to the search bar in an interactive report and made the query reference it - returning no records if the field is null, which it will be at first use.
Entering a value into this field and then hitting "enter" works fine and then users can follow up and add further filters, etc...
However, clicking "Go" does nothing. How to make this work for the "Go" button too?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.