Skip to Main Content
PLUG-INS
Long report into columns
Resizing dialog
Copy to clipboard
Time Touch Input
Restrict Shuttle
Copy Down
Store location
GENERATORS
Pipelined Function Generator
Generate substitution code
Generate getter and setter
Rewrite Query Parameters
Log statement
Align text on characters
Format APEX region source query
APEX EXAMPLES
Apex 5.0 Icons
Apex 5.1 Font Icons
Disabling items in tabular form
Usage Map
Excel Export
Disabling items selectively in tabular forms
Employee
ADAMS
ALLEN
BLAKE (Manager)
CLARK (Manager)
FORD
JAMES
JONES (Manager)
KING (President)
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Job
Download application
Description
This page demonstrates the selective disabling of items in a tabular form. All columns except empno are editable.
In the after refresh DA the items are disabled according to the autorisation.
Autorisation implemented:
- The president can change manager, salary, commission and department
- The manager can change of his job, salary and commission of his/her own employees
- Any employee can change his/her own name
More info can be found in
this blogpost
.
Tabular form on Emp
Check All
Emp#
Name
Job
Manager
Hire date
Salary
Commission
Department
(null)
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7934
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7902
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7900
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7876
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7844
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7839
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7788
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7782
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7698
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7654
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7566
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7521
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7499
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
7369
Name
Job
Manager
ADAMS
ALLEN
BLAKE
CLARK
FORD
JAMES
JONES
KING
MARTIN
MILLER
SCOTT
SMITH23
TURNER
WARD
Hire date
Salary
Commission
Department
ACCOUNTING
RESEARCH
SALES1
1 - 14
Add Row
Cancel
Delete
Apply Changes
Source query
select emp.empno
, emp.empno as empno_display
, emp.ename
, emp.job
, emp.hiredate
, emp.mgr
, emp.sal
, emp.comm
, emp.deptno
, case when emp.empno != :P300_EMPNO then 'ENAME:' else null end
|| case
when :P300_JOB = 'PRESIDENT' then 'JOB:HIREDATE'
when :P300_JOB = 'MANAGER' then case when emp.mgr = :P300_EMPNO then 'MGR:HIREDATE:DEPTNO'
else 'JOB:MGR:HIREDATE:SAL:COMM:DEPTNO'
end
else 'JOB:MGR:HIREDATE:SAL:COMM:DEPTNO'
end as disable_items
from emp
JavaScript for disabling items, executed in the after-refresh DA
function disable_tabform_items ( tabSelector )
{
// loop along all the rows with a DISABLE_ITEMS cell
$(tabSelector).find('[data-item="DISABLE_ITEMS"]').each(
function()
{
// make array of item names to be disabled
list = $(this).val().split(':');
if ( list.length > 0 )
{
// identify the row
var tr = $(this).closest('tr');
// disable all the item in the list
for ( i=0 ; i < list.length ; i++ )
{
$(tr).find('[headers="'+list[i]+'"]')
.find('input,textarea,select,button.ui-datepicker-trigger')
.addClass('apex_disabled')
.attr('tabindex','-1');
}
}
});
}