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!

Oracle Apex Interactive Grid - Alternative Definitions not showing for public (nobody) user

Jason HaydenJan 27 2020

I have an application that is defined to be public

pastedImage_0.png

I have an Interactive Grid Page with 1 saved alternative report definition

- it was saved with the "Not" Authorization since I only have one defined

pastedImage_1.png

When I access this page from a browser with no tabs logged into anything (developer or user) I do not get the drop down list for the two report definitions

pastedImage_2.png

Oddly if I do any type of column filter it will then show up and work

pastedImage_3.png

What could be causing this? I have tried the same thing with Interactive Reports and that works as expected

Things I have tried to solve this

- create a isPublic authorization scheme defined as (select 1 from dual) - saved a new alternative report with it saved to that

- create a "no authentication" authentication scheme

- turned on the run on public pages option

- defined that isPublic on the page and region

Nothing seems to make it show on first page load.....

I wonder if there needs to be an option when you save the report for public user... right now we only have the option for Authorizations schemes defined and the Not Version, Plus Must Not Be Public User

pastedImage_4.png

Any thoughts or ideas on how to get around this would be appreciated. I really would like to use the Interactive Grid for these pages

Comments
Post Details
Added on Jan 27 2020
0 comments
319 views