Apex 4.0 File Management Application

I have developed an Apex 4.0 application as a school project for the academicians of Yildiz Technical University.

Program capabilities are:

  • File storage
  • File versioning
  • User management
  • Course schedule management
  • File generator
  • Course assessment
  • etc..

Here is the link for the demo.
username: tevfik
password: 123

Thanks

Advertisements

APEX – Easy way to fill select list

In APEX 4.0 there is a cool new future to fill child select list with AJAX. Lets do it..

First we create a select list item in a region and name it as DEPARTMENT (In my case P2_DEPARTMENT).

And we configure List of Values section. I just write simple SQL:
SELECT DNAME,DEPTNO FROM DEPT

This first item is the PARENT item. Lets create the child named EMPLOYEE (P2_EMPLOYEE). Our aim is to fill Employee select list depending on selected Department.

In the List Of Values section i just put the SQL which is filtered by selected Department.
SELECT ENAME D, EMPNO R FROM EMP WHERE DEPTNO = :P2_DEPARTMENT

The key point is the Cascading LOV Parameter Item(s) parameter. I just put the Parent select list item’s name to there which means when P2_DEPARTMENT item changed, fill P2_EMPLOYEES depending on Department. :)

Apex is cool to create fast applications.