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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can I default a page item to the value of a column in the first row of an interactive report?

user1.0Apr 5 2022

Apex V 19.2
I have 2 interactive reports 1 is the master, the other is the detail.
I have it setup so the detail is populated when a link column is clicked in the master.
I did this by following these instructions (Thanks Scott!):
Scott Wesley Member Posts: 6,171 Gold Crown
Aug 8, 2018 1:03AM edited Aug 8, 2018 1:03AM
A number of ways, here is one
Create hidden item: P1_DEPTNO
In your Dept region, make Deptno a Link column
Set the link target as url: javascript:$s('P1_DEPTNO, #DEPTNO#);
Set the link text as: #DEPTNO#
Create on change dynamic action on P1_DEPTNO
Add action to refresh Emp report
In your Emp region, set Page Items To Submit: P1_DEPTNO
I'd like to automatically populate the detail report using the link column from the first row when the user clicks a Search button to populate the master report.
Also, I'm giving users the option to use the built in sort options from the action menu, so ideally the detail grid would refresh to show the detail related to the 1st row whenever the user resorted the master.
How would I get the value of the link column in my first row?
I'm assuming once I have the value of the link set in my page item I can refresh the detail report after the master report is refreshed.

This post has been answered by InoL on Apr 6 2022
Jump to Answer

Comments

vermio
Answer

The isssue was solved by Oracle Support

Marked as Answer by vermio · Sep 27 2020
1 - 1

Post Details

Added on Apr 5 2022
5 comments
1,609 views