Do you know? we can refer to current column value in oracle apex report->column attributes section.
For example there is a column of which we would like to display as a dropdown whose list of values is a SQL query containing a where clause on another column value.
Then you will need to follow these steps :
1. You will need to add htmldb_util.savekey_num(q.id) Filter as the first column in your select statement (for example: q.id column name)
2. In the reports attribute of the report, uncheck the display checkbox so this column is not displayed.
3. Change the desired column attribute to be of type select list based on LOV
4. In your LOV add the where clause restriction where q.id = htmldb_util.keyval_num
(this will then restrict the LOV to the question id of the row the LOV is displayed)
5. Done....
Hope this helps to every one....
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle APEX . Actually, I was looking for the same information on internet for
ReplyDeleteOracle Apex Interview Questions and Answers and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.