Press "Enter" to skip to content

Making Interactive Grid Rows Editable on Condition in Oracle Apex

In Oracle Apex, you can make interactive grid rows editable on condition. For example, you have a flag column APPROVED in your table, and if the APPROVED column value is N; a row can be edited else not. To do this, follow these steps:

Making Interactive Grid Rows Editable Conditionally in Oracle Apex

Create one more column in your interactive grid and set the following properties:

  • Column Name: EDITABLE
  • Type: Hidden
  • Value Protected: No
  • Source: SQL Expression
  • SQL Expression: decode(approved, ‘N’, ‘U’, ‘X’)
  • Data Type: Varchar2

If your interactive grid is based on a query, then you can add the column as follows:

Select empno, ename, sal, 
       decode(approved, 'N', 'U', 'X') EDITABLE
From emp;

Make the EDITABLE column as a hidden column.

After creating the column, click on the Attributes node of the interactive grid and specify the EDITABLE column for the Allowed Row Operations Column property. Below is the screenshot:

Oracle Apex: Allowed row operations column property.

Save the changes and run the page. Now only the rows will be editable, which are not approved.

Output:

Oracle Apex IG: Rows editable conditionally.

Related Tutorials:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
0 Comments
Inline Feedbacks
View all comments