APEX 4.0 EA1 Plugins - Google Visualization: Organizational Chart (click on the "Download Google Visualization Organizational Chart" link) How it works: 1) Install the plugin 2) Region "Organizational Chart" Voilà!
It's possible display the relationship of your company employees using the Google Visualization: Organizational Chart . How it works: I use jQuery AJAX to call an application process called GET_EMPLOYEES_RELATIONSHIP . The response is in JSON. I use jQuery to handle the JSON object. You need to store your chart data inside a "google.visualization.DataTable()" object. I use the same data table to feed the Table Chart and the Org. Chart. I created 2 examples. 1) Single Tree View Your can see a working example of the employees relationship Organizational Chart demo (1). This is how I define a data table cell: for (i = 0; i < emp_count; i++) { l_data_table.setCell(i, 0, data[i].emp_ename); l_data_table.setCell(i, 1, data[i].mgr_ename); } 2) Multiple Trees View Your can see a working example of the employees relationship Organizational Chart demo (2). This is how I define a data table cell: for (i = 0; i < emp_count; i++) { l_data_table.setCell(i, 0, data[i].emp...
I've decided to create an application to host plugins specifically made for Oracle APEX. Oracle Application Express (APEX) - jQuery Plugins Send me your plugins so we can all enjoy them!
Comments
Congrats! Keep up the good work.
Martin
Johannes
Just keep going like this.
Thanks,
Bhavin
If you do it, do it Béton! :)
How about a real-time application with Websheets theme for the 2nd year?
Pradeep
What do you think?