Pretius APEX Context Menu

Employee	Job	Superior	Hire date	Salary	Commission	Department	City
JONES	MANAGER	KING	02-APR-81	$2,975.00	-	RESEARCH	DALLAS
SCOTT	ANALYST	WARD	19-APR-87	$3,000.00	-	OPERATIONS	BOSTON
FORD	ANALYST	ALLEN	03-DEC-81	$3,000.00	-	OPERATIONS	BOSTON
SMITH	CLERK	ADAMS	17-DEC-80	$800.00	-	OPERATIONS	BOSTON
ALLEN	SALESMAN	CLARK	20-FEB-81	$1,600.00	$300.00	OPERATIONS	BOSTON
WARD	SALESMAN	MARTIN	22-FEB-81	$1,250.00	$500.00	OPERATIONS	BOSTON
TURNER	SALESMAN	SMITH	08-SEP-81	$1,500.00	$0.00	SALES	CHICAGO
ADAMS	CLERK	MILLER	23-MAY-87	$1,100.00	-	OPERATIONS	BOSTON
JAMES	CLERK	CLARK	03-DEC-81	$950.00	-	ACCOUNTING	NEW YORK
MILLER	CLERK	MILLER	23-JAN-82	$1,300.00	-	ACCOUNTING	NEW YORK

Live demo contains several use cases of the plugin. Menus behaviour might be affected by authorization scheme result. Please read description of each use case to learn more.

In all cases menu is generated based on defined APEX list.

Checkbox menu containss 5 static Entries: "All", "None", "Entry separator", "By job" and "By department". Entries "By job" and "By department" are extended using JSON object to provide second level of menu with dynamic entries based on jobs and departments in emp table.

Features

Menu can be invoked only by click on icon next to the checkbox in header of table.
Clicking on dynamic entries via submenu of "By job" and "By department" selects only visible rows with given trait (job or department)

Row menu contains 13 static entries which visibility is affected by result of authorization scheme.

Features

Menu can be invoked only by click on .
List entries are affected by result of authorization schemes. If edit privilege is not granted enrties are not rendered.
Every entry but "King" can be deleted
Entries "Change superior", "Change job" and "Change department" are dynamically extended with JSON object based on data from emp and dept tables.

Cell menu is based on empty APEX list and extended with JSON adding extra entries based on emp and dept tables. Similar effect can be achieved with dynamic (SQL Query) list but disabling current job / department / superior would need defining rules per distinct job / department / superior.

Features

menu can be invoked only by clicking with right mouse button on cell in column "Job", "Superior" and "Department"
current job / department / superior can't be selected
menu is not invocable if edit privilege is not granted.

Breadcrumb menu is based on static APEX list with 3 entries and are affected by result of authorization scheme. Entry "Reload data" resets data in collection availble via classic report. Entry "Disable edit" and "Enable edit" changes result of authorization scheme which is used for this live demo.

Context menu on region is same menu implemented as Breadcrumb menu but it can be invoked only by clicking right mouse in area of region displaying information about authorization scheme. Menu position is being positioned to "event.pageX" and "event.pageY" attributes.

Pretius APEX Context Menu

Data loaded to collection.

Edit mode is OFF

Description

Description

Checkbox menu

Row menu

Cell menu

Breadcrumb menu

Context menu on region