File Type Validation using Java Script
Step 1: Create a File browse item. Step 2: Create a button to submit the page. Give the Action when Clicked as Defined by Dynamic Action. Step 3: Create a…
Read MoreDynamically ordering of rows
Step 1: Create a tabular form with the query and add a null column at last Step 2: Report attributes à NULL column à HTML Expression <img id=”down_#ROWNUM#” style=”cursor:pointer;” onclick=”f_row_down(this)”…
Read MoreModal 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 More