Modal Dialog in Apex 4.2
Requirement: A modal dialog has to open on button click in Oracle Apex 4.2. Step 1: Create a page Step 2: Create a HTML static Region and create a…
Read MoreAPEX 5- Using Images as an Top Navigation Menu
Overview: 1. Purpose. 2. Benefits. 3. Steps. 4. Screen shots. 5. Conclusion. 1. Purpose: This document describes how to Use an Favicons in Apex 5 Top Navigation Menu. In Apex 5, Navigation Menu Position is…
Read MoreAPEX – Reports with Row Details
Overview: 1. Purpose. 2. Benefits. 3. Steps. 4. Screenshots. 5. Conclusion. 1. Purpose: This document describes how to show a Apex Reports with Row Details In Apex, Report is an important tool which is in classical,…
Read MoreDeep Linking in Oracle APEX :
Deep linking refers to the ability to link to an Oracle Application Express page out of context . When you link to a page out of context and the application…
Read MoreWord Wrap in APEX IR:
One of the common problems with APEX IR is word wrap. Add the below code in Column formatting in column attribute: <table style=“word-break: break-all; width:100px”> <tr> <td >#COLUMN_NAME# </td> </tr> </table>
Read MoreAPEX – Report Rows Clickable to detailed page
Overview: 1. Purpose. 2. Benefits. 3. Steps 4. Conclusion. 1. Purpose: This document describes how to make a Apex Reports clickable to detailed page with an option of entire row selection. In Apex,…
Read MoreFreeze Columns in Tabular Form/ Report (Classical Report)
Today I would like to share “How to Freeze/Fix Column Header Row of a Classic Report” which I found very useful when the number of report columns/rows are more per…
Read MoreSearch bar for Tabular form with auto complete option for Date values
Requirement: Tabular form Search bar Challenges faced: On default, in tabular form Oracle apex didn’t provided the Search option. Solution: 1. Created a page level select list item to display all the column names. 2. Created a text item (which will act as select list also on selecting date value in previous item) for user to enter the search value. 3. Created 2 buttons, one for searching and other to clear the previously entered value. 4. Modified the existing report query as SELECT NULL, delivery_item_id, master_item_id, delivery_pdvd_id, item_id, program_name, output_name, title, “Item_type”, “Theme”, “Unique_Replicate_Indicator”, “Replicate_of”, rerun, validation_type, “Hold”, “Hold Status”, developer_id, dev_proj_complete_date, dev_status, dev_pending_reason, dev_act_complete_date, dev_status_comments, validator_id, valid_proj_complete_date, valid_status, valid_pending_reason, valid_act_complete_date, valid_status_comments, reviewer_id, review_proj_complete_date, review_status, review_pending_reason, review_act_complete_date, review_status_comments, validation_program_name, dev_check, valid_check, review_check, overall_check, cdars_standards, “Role”, general_comments, SEQUENCE, gc FROM (SELECT ROWNUM rnum, NULL, delivery_item_id, master_item_id, delivery_pdvd_id, item_id, program_name, output_name, title, “Item_type”, “Theme”, “Unique_Replicate_Indicator”, “Replicate_of”, rerun, validation_type, “Hold”, “Hold Status”, developer_id, dev_proj_complete_date, dev_status, dev_pending_reason, dev_act_complete_date, dev_status_comments, validator_id, valid_proj_complete_date, valid_status, valid_pending_reason, valid_act_complete_date, valid_status_comments, reviewer_id, review_proj_complete_date,…
Read MoreShrinking of Navigation Menu on page load
Requirement: Navigation menu should be shrinking on page load. Challenges faced: In Oracle Apex 5, universal theme the navigation menu is strengthening on default page load. If we want to shrink the menu we need to click on the navigation menu controller. Resolution: 1. Created a dynamic action with event as page load and condition as JavaScript Expression and value as $(‘#t_Button_navControl’).attr(‘aria-expanded’) === “true”. 2. A true action is provided with JavaScript code as $(‘#t_Button_navControl’).click(); Output:
Read MoreDisplaying of 7 Consecutive Dates in Report Header
Step 1: Create a date field for selecting the date. Step 2: Create a report for displaying the data in those dates. Step 3: Enter the following code in the page header Code: $(function() { var month = new Array(); month[0] = “Jan”; month[1] = “Feb”; month[2] = “Mar”; month[3] = “Apr”; month[4] = “May”; month[5] = “Jun”; month[6] = “Jul”; month[7] = “Aug”; month[8] = “Sep”; month[9] = “Oct”; month[10] = “Nov”; month[11] = “Dec”; var from_date = $(“#P215_FROM_DATE”).val(); //alert(‘from_date’+from_date); var sec_date = new Date(from_date); //alert(‘sec_date’+sec_date)); sec_date.setDate(sec_date.getDate() + 1); //alert(sec_date.setDate(sec_date.getDate() + 1));…
Read More