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!

Faceted Search -> Checkbox Group -> LOV Distinct gives error ORA-30563

mtMay 5 2022 — edited May 5 2022

Hello
I've been playing with the Faceted Search. When I use a Checkbox Group with LOV using TYPE: SQL query using Distinct, it works as expected.
When I use a Checkbox Group with LOV using Type; Distinct , I get the following error message:
Ajax call returned servor error ORA-30563 outer join operator is not allowed her for Filter.
As I haven't typed any code, I don't know how to fix that.. Is the filter looking at the code in my underlying view, where I might have an outer join?
Thank you-

Comments
Post Details
Added on May 5 2022
7 comments
101 views