CODEWITHSUNDEEP
oracle-apex
Caffeinated
Caffeinated

Reputation: 12474

In Apex, how do you add in an edit column?

In order to edit a row in APEX, what is the procedure? I found this link, from 2009 , but it appears to be outdated , because I don't see any pencil & paper icon to the left of the EDIT_LINK columns :

How do you add an edit button to each row in a report in Oracle APEX?

enter image description here

Upvotes: 0

Views: 3247

Answers (1)

Typo
Typo

Reputation: 1900

1- Create a Classic report with a normal query (including a key column, like empno in this case):

select  empno, 
        name,
        job,
        hiredate
from emp

2- Select the column that will serve as a button:

Column empno

3- Go to Column Formatting -> HTML Expression on the attributes display region: and paste this code:

<button class="t-Button  " id="#EMPNO#" onclick="showRow(#EMPNO#);" type="button"><span class="t-Button-label"> + </span></button>

html wRAP

4- This will generate a button associated to each "empno", notice that I'm setting the id of the button to #EMPNO# (being the value of empno to that row) and I'm setting an onclick call to a javascript function called showRow(empno). In this function is where you'd call either a new page passing the parameters needed or show a modal popup whit the fetched data to beeing modified.

Here's a working example

Upvotes: 1

Related Questions