Refer to current column value in oracle apex report.

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....