Oracle APEX Tips & Techniques

For showing tooltips on Gantt Charts, just go to "Gantt Chart > Attributes > Tooltip" and select "Yes" for "Show" option. However, this will show standard tooltip and there is no option for customization. In APEX ver. 20.1, there are few more granular options to control on data we want to display in the tooltip. However, still we need to choose from existing options. Luckily, we can implement custom tooltips in relatively easy way. If you are new to Gantt charts, I recommend you to read  Few tips on Gantt Charts  blogpost first. Gantt Chart Options First, we need to specify JavaScript function name, which will return a tooltip element, in the Gantt chart options. In below code "showCustomTooltip" is JavaScript function which return the tooltip element. function (options) {   options.tooltip = {"renderer":showCustomTooltip};   // with older APEX (JET) versions use below code   // options.tooltip = showCustomTooltip;   return option...

Whenever I need to modify any backend object (altering table, modifying view or changing function/procedure specifications etc.), then I search for object usage in APEX using "Application Search". Sometimes, I find several references for the object and I wish if I could just export them into a excel/csv file, so that I can review them at later point. However, there is no "export" functionality available in "Application Search" pop-up page (APEX Builder Application 4000, Page 8000).  So, I have written below JavaScript code to export search results into a CSV file. (function () {     // CSV delimiter     var csvDelimiter = ",";     var encloseChar = '"';     // define array to hold search results var refArr = [];     var refPath, refAttr, refPathPrev;     // add headers     refArr.push("Reference Path" + csvDelimiter + "Attribute");     // append search results to array $("table.htmldbStandard3").eac...

In one of my previous blog post,  Few tips on Gantt Charts , I have explained how you can create Gantt chart to show employees calendar data. In this blog post, I am going to explain two more tips on the Gantt chart. This is continuation of previous blog post. So, if you have not read it yet, I recommend to read it first and then come here. Vertical Grid for Minor Axis If you go to Gantt Chart > Attributes, there you can enable vertical and horizontal grid lines using "Show Vertical Grid" and "Show Horizontal Grid" options. In our example, horizontal grid lines displays a line after every employee row. This looks good. However, vertical grid lines are displayed based on "Major Axis". So if "months" are displayed as scale for major axis, then vertical grid line is displayed after every month. However, it will be helpful if we display vertical grid line after every day (minor axis), especially when there are several employees in the Gantt chart....