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!

How to show data from another table row-wise into a specific column in the Interactive Grid?

MD. SAYDUL ISLAMOct 4 2023 — edited Oct 4 2023

I have two tables. (1) Issue_tbl (2) comments_tbl. I want to show issue_id wise comments into COMVIEW column from Comments_tbl and other columns data are showing from Issue_tbl. (Where comments_tbl.Issue_lnk=issue_tbl.issue_id)

Here I used a dynamic action. Page load, Action= set value,

Sql Statement: select comment_name from comments_tbl

where

comment_date=(select max(comment_date) from comments_tbl where issue_lnk=:ISSUE_ID)

Affected Elements: Columns > COMVIEW.

But data not showing.

Please help about …….

Added on Oct 4 2023

1 comment

71 views