📋 One-Click Copy: Export Interactive Report Rows as CSV in Oracle APEX

-

🚩Introduction 

  • In modern Oracle APEX applications, it is important to make data easy to access and use. A useful feature is letting users copy a row of data from an Interactive Report as comma-separated values (CSV) directly to the clipboard.

  • With a simple click on a copy icon in a row, users can quickly copy all the values in that row. They can then easily paste it into Excel, emails, or documents. This makes work faster, improves productivity, and keeps the application simple and easy to use.

📑 Why This Approach Is Needed

In Oracle APEX applications, users often need to quickly copy report data and use it in tools like Excel, emails, or documents. Doing this manually can take time, lead to mistakes, and feel less efficient.

Allowing row-level data to be copied as comma-separated values (CSV) becomes important when:

  • Users want to copy a full row with a single click

  • Data needs to stay structured and accurate

  • Users should be able to paste it directly into tools like Excel or emails without extra formatting

  • Applications aim to reduce manual work and improve productivity

  • A simple and smooth user experience is important

This approach helps users work faster, reduces errors, and makes the overall experience smoother while keeping everything simple and well integrated in Oracle APEX.

👉 Use Case: Copying Interactive Report Row Data as CSV in Oracle APEX

In Oracle APEX, users often need to quickly copy specific row data from an Interactive Report to use in tools like Excel, emails, or documents. Adding a copy icon for each row allows users to instantly copy the row data as comma-separated values (CSV) to the clipboard.

In this blog, we will see how to implement this feature in Oracle APEX using JavaScript. It helps users copy and reuse report data with a single click, making work faster, improving productivity, and simplifying everyday tasks.

Step 1: 

In the page designer, create a region and change the type to Interactive Report and set the source type as SQL query and copy the SQL Query below.


SELECT EMPNO,
       ENAME,
       JOB,
       MGR,
       HIREDATE,
       SAL,
       COMM,
       DEPTNO,
       '' -- icon placeholder
  FROM EMP;

 Step 2: 

Click on the icon column in the Interactive Report and navigate to the HTML Expression in the properties section and copy the below HTML Code. On clicking this icon, we will call the javascript function copyRecord() to copy the contents to the clipboard.

<!-- Copy Icon for Each Row in the HTML Expression -->

<span class="fa fa-copy copy-icon" title="copy record" onclick="copyRecord(this)"></span>

Step 3: 

Now Click on the page and go to the Function and Global Variable Declaration section and copy the below javascript function to copy the contents to the clipboard. 

function copyRecord(el) {
  var row = $(el).closest('tr');
  var values = [];

  //Get the row values excluding the copy icon column
  row.children('td').each(function () {
    if ($(this).find('.copy-icon').length === 0) {
      values.push(this.innerText.trim());
    } 
  }); 

  // Copy the contents to the clipboard
  var record = values.join(",");
  if(record != ""){         
    navigator.clipboard.writeText(record);
    apex.message.showPageSuccess("Copied");
  }      
}

Step 4: 

Now save and run the page, you will see the report rendered in the page, clicking on the copy icon in each row, the respective row data will be copied to the clipboard as comma seperated value.





🔥 Conclusion

Thus, in Oracle APEX, adding a copy icon to each Interactive Report row allows users to quickly copy data as CSV using JavaScript. This makes it easy to reuse data in tools like Excel or emails, reduces manual effort and errors, and improves overall usability while keeping the implementation simple.  


Comments

Post a Comment

Popular posts from this blog

🔍 Extending Smart Search Filter for Multiple Regions

-
Image
🚩Introduction  In Oracle APEX, the Smart Search filter is a convenient feature that allows users to quickly search data in a Classic Report or Cards region without writing custom code. However, this functionality is limited to a single region , which can be restrictive when a page contains multiple regions that should respond to the same search input. In this tutorial, you will learn how to extend the Smart Search filter to work with multiple regions on the same page . We will implement a solution that allows one Smart Search input to drive filtering across multiple Classic Report ,Cards regions etc. By the end of this tutorial, you’ll have a clear, reusable approach for coordinating search behavior across regions, improving both usability and consistency in your Oracle APEX applications without breaking the declarative nature of APEX. 📑 Why Extending the Smart Search Filter Is Needed The built-in Smart Search filter in Oracle APEX works well when a page contains a single sear...
Read more

📌Track Active Tab switch in Region Display Selector without any plugins

-
Image
🚩Introduction  In Oracle APEX applications, Region Display Selector components helps to organize multiple regions efficiently. However, APEX does not provide a built-in declarative option to detect which tab is active when users switch between them, making it challenging to trigger conditional logic based on tab selection. This can be solved by creating the custom dyanamic action to capture the tab change. This approach enables dynamic actions like refreshing regions or executing custom logic whenever a tab becomes active, without requiring any plugins. 📑Why It is Essential to Track Tab Selection in Region Display Selector In APEX applications, pages often organize multiple regions under a Region Display Selector to separate content like Details, History, or Reports. While this improves layout, users actions on different tabs often require specific logic to run, such as refreshing a region, loading dynamic content, or updating page items. Without capturing which tab is active, de...
Read more

💡 Designing Dynamic QuickPicks in Oracle APEX

-
Image
🚩Introduction  Oracle APEX provides Quick Picks as a convenient way to allow users to populate page items with predefined values using a single click. While static Quick Picks are useful, real-world applications often require these values to be generated dynamically based on business rules, user roles, or underlying data. This blog explores how to implement Dynamic Quick Picks in Oracle APEX page items , enabling developers to build more intelligent, flexible, and user-friendly forms by driving Quick Pick values directly from database queries and runtime logic.  📑 Why Dynamic Quick Picks Are Needed   Static Quick Picks in Oracle APEX are useful for simple filtering, but Dynamic Quick Picks become essential when: Filter values must be generated at runtime based on current data, user role, or context Applications require data-driven filters instead of hardcoded values The same Quick Picks must adapt across multiple pages or regions Filter options depend ...
Read more