CODEWITHSUNDEEP
oracle-databaseoracle-apex
TJo
TJo

Reputation: 28

How to link report page to interactive grid form in Oracle Apex

I have an application named demo_app. It contains 3 pages; these are respectively interactive report, form and interactive grid form:

I want to link project_rpt with show_milestone_grid.

project_rpt has a column named "milestone". I want to link this column with show_milestone_grid that will show only those projects's milestone.

When I try to link this column, it is not showing any column for that page.

Example is as below.

page:project_rpt

project              description            milestones    
----------   
A                    test                   2      
B                    test2                  3

so when I click on milestones for project A, it should show below:

Page:show_milestone_grid

Project                  milestones    
----------    
 A                       my_mstone_1    
 A                       my_mstone_2

I am not able to link report page with interactive grid form. For normal form I can link, but I want to link grid form.

Upvotes: 0

Views: 2055

Answers (1)

Littlefoot
Littlefoot

Reputation: 142743

Here's how:

  • as you've already created project_rpt and show_milestone_grid pages, I'll presume that everything's left as the Wizard did
  • on show_milestone_grid page (interactive grid, right? Let's name it "Page 3"), create an item and name it P3_MILESTONE
  • set P3_MILESTONE's type to hidden (you aren't really interested in seeing it)
  • modify its query and add a WHERE clause as where milestone = :P3_MILESTONE
  • on project_rpt page (interactive report; that would be "Page 1"), navigate to report's attributes and
    • set link column to "Link to custom target"
    • target is Page 3 (show_milestone_grid)
    • in set items, set previously created P3_MILESTONE to accept value of the #MILESTONE# column from Page 1 (project_rpt)

That's all - save & run. When you click the link column in the interactive report (Page 1), you'll be redirected to interactive grid (Page 3) whose P3_MILESTONE item will accept value of the interactive report's MILESTONE column and filter result row set in the interactive grid.

Upvotes: 1

Related Questions