ROW FILTER NOT WORKING WHEN 'IS' OR 'OR' IS USED IN EXPRESSION
(Doc ID 2367732.1)
Last updated on JUNE 17, 2021
Applies to:
Oracle Application Express (APEX) - Version 5.1.4.00.08 and laterOracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When using APEX interactive reports, the Row Filter fails with certain options. For example, when the column_alias is like 'IS' or 'OR' you cannot use 'IS' or 'OR' as a operator in the filter setting. When you try to save this,
the following error appears :
ORA-00907
When tested using apex.oracle.com a different error is presented:
Invalid filter expression. ORA-00936: missing expression
Example:
Column alias1: OR
Column alias2: AA
Row Filter that produces this error, because the operator and column alias1
are the same:
AA = 1 or OR = 2
Run the application
From Actions -> Filter -> Row
Name - enter 1
Filter Expression: AA = 1 or OR = 2
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |