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!

APEX filtering in grid not working when using function body returning SQL query

529017Jul 11 2021

When I use function body return SQL Query and have a column which is a number like Age and use the APEX filtering > 67 it only ever executes = 67 instead of > 67

Interestingly using the > sign on dates works. Using a > on a varchar2 column like last_name also does not work for example > F
Using a grid on a table/view the filtering works as expected.

Comments
Post Details
Added on Jul 11 2021
1 comment
326 views