Skip to main content

Explore

Interactive Grid

This blog post explains about performing bulk custom operation on selected rows of interactive grid using an example.

This blog post explains how we can select a row from classic or interactive report and add it to interactive grid using JavaScript.

This blog post explains how we can perform validations at grid level, i.e. validations that may involve more than one row of interactive grid.

This blog post explains how we can perform validations at grid level, i.e. validations that may involve more than one row of interactive grid using JavaScript.

This blog post discusses few approaches using which we can conditionally enable/disable Interactive Grid Column(s) using other column(s) values. It covers cases of both "simple client side condition" as-well as "complex conditions that may require sever side evaluation".

This blog post discusses few approaches using which we can customize options displayed when user clicks on Interactive Grid column header. As an example "(Blanks)" filter is added to column header options, using which user can quickly filter for all rows where the column value IS NULL.

This blog post explains an approach to show selected master record information in details IG region header. This will be helpful for users to understand the master row context, especially when there are multiple master-details IGs on the same page or when there are multi level master-details IG on a page.

Freezing important columns will make life easy for users when entering or viewing data and it works well on large screens. But in small screens, frozen columns do not give better user experience. This blog post provides sample JavaScript code to freeze, unfreeze IG columns based on screen size. 

Email & Email Template

Introduction to Oracle APEX Email Template feature. If you are not aware of Email Templates or not worked yet, you may find this blog post helpful.

This blog post discusses few approaches using which we can hide/show part of the email template conditionally.

This blog post provides a generic solution to include dynamic tabular data in email templates.

This blogpost explains different ways using which we can include images as part of the email content.

Gantt Chart

All you need to know for displaying employee calendar using Gantt Charts (Multiple Tasks Per Row).

It's continuation of previous blogpost where few more tips about Gantt Chart are discussed. Tips discussed are "Vertical Grid for Minor Axis" and "Dynamic Height for Gantt Chart".

This blog post explains how we can show custom tooltips on Gantt Chart Task bars.

This blog post provides a work around for implementing "Link" feature in Gantt Chart.

When using Gantt charts to display different types of data and we want to use unique colors for each data type, then we may soon run out of colors. That time, using patterns as background will be more helpful and intuitive for users. This blog post provides an example on how we can use SVG patterns as background for Gantt charts task bars.

Others

This blog post discusses read only condition types "Always" and "Never" and when and how we can use them.

Quick introduction to new friendly URLs feature introduced in version 20.1

This blog post touches upon few interesting points I have discovered in my Oracle APEX journey. If you are new to Oracle APEX development, you may find this blogpost useful.

When we define "Help Text" for page items, then APEX displays a little "?" icon next to the page item. For Interactive Grids (IG), help icon is displayed when users click on the column header. When we click help icon, then we can see the help text defined for the item. In some cases, this may not be very handy for users. In this blogpost, I am going to explain a simple approach to proactively display item's and IG column's help text to users.

This blog post tries to measure the performance difference of using "Application Context APEX$SESSION" vs V function to get APP_USER value, with a simple use case.

Simple JavaScript solution using which application search results (from Application Builder) can be exported into a CSV file.

Do you know you can convert your radio buttons into something stylish and fancy almost declaratively in Oracle APEX? If you are not aware about this, then you may find this blog post useful. 

Simple JavaScript solution using which we can restrict users from opening APEX page(s) using multiple tabs in same browser.

This blog post provides an approach to implement the search feature for Oracle APEX trees. 

Comments

Unknown said…
how can we download your sample application. I would like to explore back-end code.
August 10, 2020 at 12:00 AM
Hari said…
Hi,

At present it's not open for download. (I need to set-up supporting objects and need to clean it before publishing)

However, all the code you need is already available in respective blog posts. If you need any help on any specific example, please let me know. I can try to help.

Regards,
Srihari
August 10, 2020 at 3:33 PM
Post a Comment

Popular posts from this blog

Interactive Grid - Conditional Enable/Disable

In this blogpost, I am going to discuss few approaches using which we can conditionally enable/disable Interactive Grid (IG) column(s) based on other column(s) values. Note:    There is a bug  30801170  in APEX 19.2/20.1 with respect to "enable/disable" dynamic actions for IG columns. Workaround for this bug is provided at the end of this blogpost . This bug has been fixed in APEX version 20.2. Client Side Only Conditions If conditions to enable/disable are simple, then we can check those conditions easily on the client side. For e.g. let's consider IG on EMP table with following SQL Query. SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM EMP Let's consider the requirement as - Enable "Commission" column only when JOB is equals to 'SALESMAN' and disable "Commission" column in all other cases. This can be done declaratively using dynamic actions (DA) DA "Enable/Disable Commission - 1" Create DA and give it a prope...
4 comments
Read more

Interactive Grid - Bulk Operation on Selected Rows

What's the Problem? Let's say you have an IG on employee table and you want to update selected employees commission based on user's input. Ideally, it should be very simple, where you can write UPDATE statement in page process and select IG region as "Editable Region" under "Execution Options" of the page process. But, when you select rows and submit page, you can see that, this process won't get executed! The reason is  Selection of 'Row Selector' check-boxes is not considered as row-change. Thus selected rows are not submitted to server. So, is there any work around?  Yes! Luckily there are lot of JavaScript (JS) APIs available to work with IG. If you are not already aware, you can refer "APEX IG Cookbook"  or  JavaScript API Reference documentation. If we continue with above Employee IG example, when user selects IG rows, enters "Commission %" and clicks on "Update Commission" button, then we can writ...
36 comments
Read more

Interactive Grid - Process Filtered Data on Server Side

Recently one of the APEX developers has reached out to me and asked if it's possible to capture filtered rows data of the Interactive Grid on the server-side and do some processing. In APEX 20.1, there is a new API APEX_IG , using which we can achieve this. Photo by Jakub Kapusnak on Unsplash The approach is very simple and straightforward. Get the internal region id based on the Static ID given for the IG region Get the last viewed report id based on region id Open query context for the region and report using region id and report id Fetch and loop through the rows using the query context Do something with fetched rows And finally, close the query context If you have already done this for interactive reports, then you should be already aware of these steps. The only difference here is, we use APEX_IG APIs instead of APEX_IR APIs. For the demo purpose, let's Build an Interactive Grid on EMP table and let's give it a Static ID as emp Create a Textarea page item with...
1 comment
Read more