APEX

Add Row on the Top in the APEX Tabular Form

Step 1: Give the Add row button, Action when Button Clicked as Defined by Dynamic action. Step 2: Create a Dynamic action with Event as Click, Selection Type as Button, Button as Add_row and true action as Execute JavaScript Code with Fire on Page load No and add code as addRowTop(); Step 3: Create a function in page header as function addRowTop() { apex.widget.tabular.addRow(); apex.jQuery(apex.widget.tabular.gTabForm).find(“tr”).last().insertBefore(apex.jQuery(apex.widget.tabular.gTabForm).find(“tr”).first()); }

Avoid wrapping of fields in APEX Interactive reports

Due to many columns in the report the data will be wrapped automatically. Resolution: 1. In report attributes, assign the static ID for the column that you want not be shrink. 2. Add the following code in the page header to remove the wrapping. $(function() { $(“td[headers=column_name’]”).attr(“nowrap”,”nowrap”); }); Output:

Sending Calendar Invite via APEX Application

With the below code we can send individual emails to the users with an ICS file as attachment. ICS is a global format for calendar files widely being utilized by various calendar and email programs including Google Calendar, Apple iCal, and Microsoft Outlook. These files enable users to share and publish information directly from their calendars over email or via uploading it to the world wide web. Step 1 : Compile the below code CREATE OR REPLACE FUNCTION ical_events ( p_summary IN VARCHAR2, p_description IN VARCHAR2, p_start_date IN DATE, p_end_date IN DATE ) RETURN VARCHAR2 AS lv_desc VARCHAR2 (20000); lv_summary VARCHAR2 (10000); lv_dtstart VARCHAR2 (100); lv_date VARCHAR2 (100); lv_dtend VARCHAR2 (100); l_retval VARCHAR2 (32767); l_lf CHAR (1) := CHR (10); BEGIN lv_summary := ‘SUMMARY:’ || p_summary; lv_date := ‘DTSTAMP:’ || TO_CHAR (SYSDATE, ‘RRRR-MM-DD’) || ‘T’ || TO_CHAR (SYSDATE, ‘HH24:MI:SS’); lv_dtstart := ‘DTSTART:’ || TO_CHAR (p_start_date, ‘RRRR-MM-DD’) || ‘T’…

Download hidden column in APEX classic report

Hidden column cannot be downloaded in classic report if, Display As : Hidden Include In Export : Yes This can be achieved using the PLSQL Expression: Column attributes-> Display As : Display as Text Column attributes-> Conditional display-> Condition Type : PLSQL Expression Expression : apex_application.g_excel_format = TRUE

Manual Pagination In Oracle Apex

Step:1 : Create items to set count of rows and display item to represent pagination. Also create buttons to navigate different pages. PXX_FROM – From Value PXX_TO – To Value PXX_MAX – Max Value PXX_PAGINATION – Rows per page PXX_PAGINATION_DISPLAY – Pagination Display Buttons: Save and Next,Save and Previous, First Page,Last Page Step:2: Restrict data with specified range in report query, Query is displayed as follows SELECT master_item_id, master_item_id_display, master_pdvd_id, item_id, col1, col2, col3, col4, col5, col6, col7, col8, col9, NULL, “Check”, active_ind, SEQUENCE, “replicate_of” FROM (SELECT ROWNUM rm, master_item_id, master_item_id_display, master_pdvd_id, item_id, col1, col2, col3, col4, col5, col6, col7, col8, col9, NULL, “Check”, active_ind, SEQUENCE, “replicate_of” FROM (SELECT c001 master_item_id, seq_id master_item_id_display, c002 master_pdvd_id, c003 item_id, c004 col1, c005 col2, c006 col3, c007 col4, c008 col5, c009 col6, b.c010 col7, c011 col8, NULL col9, NULL, NULL “Check”, c012 active_ind, (SELECT display_order FROM pdvd_tb_lov_dict WHERE lov_id = b.c008) SEQUENCE,…

Losing Data During Validation In Apex Tabular Form !!! – Check In

Step:1: On Submit, Before Computation and Validation – Insert into Collections. BEGIN apex_collection.add_member (p_collection_name => ‘PDVD_MASTER_ITEM_DTLS’, p_c001 => apex_application.g_f03 (i), p_c002 => NVL (:p77_master_pdvd_id, NULL ), p_c003 => apex_application.g_f04 (i), p_c004 => apex_application.g_f05 (i), p_c005 => apex_application.g_f06 (i), p_c006 => apex_application.g_f07 (i), p_c007 => apex_application.g_f08 (i), p_c008 => apex_application.g_f09 (i), p_c009 => apex_application.g_f10 (i), p_c010 => lv_v_master_repli_of, p_c011 => lv_v_delivery_types, p_c012 => apex_application.g_f15 (i) ); EXCEPTION…

Field Locks In Oracle Apex

Step:1: On-change of items, insert into locks table. Dynamic Action : On-Change Selector : JQuery Selector [name=f05] Execute Javascript Code, /* Getting the Program Name Details*/ var c=($(this.triggeringElement ).attr(‘name’).substr(0,3)); var d=this.triggeringElement.id; //alert(d); var str = d.substring(4,8); if(c==”f05″) { // Assigning PDVD Type var p_pdvd_type=”Master”; //alert(p_pdvd_type); //getting column header value idheader =”#f05_0001_LABEL” ; var p_field_name = $(idheader).closest(“label”).html(); //alert(p_field_name); //getting Master PDVD ID var p_pdvd_id=$(‘#P77_MASTER_PDVD_ID’).val(); //alert(p_pdvd_id); //getting Item ID var p_item_id=$(this.triggeringElement ).attr(‘id’); //alert(p_item_id); //getting Item value var p_item_val=$x(p_item_id).value;…

Excel Merge and Download using Custom Template in APEX

For Merging cells in Excel and for other CSS in download property, i.e to create down loadable XLS formatted sheets from any version of APEX use the following steps: 1. Create a new blank page in the application using Customized template. In that customized template remove all the contents in the page, like navigation menus, APEX page Toolbar, and others , since by putting this in a Before Header process on a page, the entire page will be downloaded as a native Excel Spreadsheet. 2. Create PLSQL Region with no template. — Should use recursion for a full tree, but we only need executives. DECLARE l_dirtotal NUMBER (12, 2); BEGIN HTP.p (‘<table border=1 white-space=nowrap><tr style=”background-color:silver;”> <th colspan=5>Employee</th><th>Title</th><th>Salary</th> <th>Direct Report Total</th></tr>’ ); FOR c_exec IN (SELECT * FROM employee WHERE direct_report_id IS NULL) LOOP SELECT SUM (salary) INTO l_dirtotal FROM employee WHERE direct_report_id = c_exec.ID; HTP.p ( ‘<tr height=80><th align=right><img src=”‘ || c_exec.image || ‘”></th><th colspan=4 style=”white-space:nowrap;font-size:36px;color:green;background-color:#CCFFCC;”>’ || c_exec.NAME || ‘</th><th>’ || c_exec.title || ‘</th> <th style=”font-size:36px;”>’…

Get Filtered Columns and Values in APEX Interactive Report

In order to get the filtered columns and their corresponding values in APEX Interactive Report, we can use this code. So if the user selects multiple filters in IR and we need to retrieve the values of filter columns and their corresponding values, conditions, operators used for the conditions,etc we can retrieve using the below code: SELECT ircond.condition_name, ircond.condition_type, ircol.report_label, ircond.condition_column_name, ircond.condition_operator, ircond.condition_expr_type, ircond.condition_expression, ircond.condition_expression2, ircond.condition_sql, ircond.condition_display, ircond.condition_enabled FROM apex_application_page_ir ir JOIN apex_application_page_ir_rpt irr ON ir.interactive_report_id = irr.interactive_report_id JOIN apex_application_page_ir_cond ircond ON irr.report_id = ircond.report_id JOIN apex_application_page_ir_col ircol ON ir.interactive_report_id = ircol.interactive_report_id AND ircond.condition_column_name = ircol.column_alias WHERE ir.application_id = TO_NUMBER (:app_id) AND ir.page_id = TO_NUMBER (:app_page_id) AND ir.region_name = ‘Interactive Report’ AND ircond.condition_type = ‘Filter’ AND irr.session_id = :app_session AND irr.base_report_id = (SELECT apex_ir.get_last_viewed_report_id (TO_NUMBER (:app_page_id), ir.region_id ) FROM DUAL) Use a condition to identify the specific interactive report using either the region name or a static region ID. Note: Can filter using Actions Menu and also using Header column filter. Example: The below filtered columns and corresponding values can be retrieved using the above code.

Highlight Tabular Form Rows on addition from Pop-up

To Highlight Tabular Form Rows on addition from Pop-up: 1. Paste the following code in the dynamic action: On Refresh of region …

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey