Skip to main content

This blog will teach you how to conditionally render an error button on an Interactive Grid (IG) in Oracle APEX. To review some of the techniques used and learn about alternative solutions, please take a look at our other blog on Creating Dynamic Links for Interactive Reports.

Problem

Interactive Grid columns don’t always have enough space to display larger text strings. An easy workaround would be to just to hide those larger text columns. However, what if we have a column that needs to display error descriptions if an error occurs?

In that case, it is necessary to keep the column, but make it more user-friendly. One of the ways we can accomplish this is to have a link display in the column if an error occurs, and have that link open a popup with the error text.

Interactive Grid Button and Query

After you add an Interactive Grid region to your page, use this query below:


select  t1.ID
,t1.ITEM_NUMBER
,t1.ITEM_DESC
,case when t1.ERROR_CODE is not null then
'<span class="t-Button t-Button--small t-Button--danger
t-Button--stretch view-error-action"> VIEW ERROR </span>' end as "ERROR_CODE"
from ITEM_TABLE as “t1”
left outer join ITEM_TABLE as “t2” on (t1.ID = t2.ID)

We used essays on hope and other dangerous pursuits https://rainierfruit.com/how-expensive-is-viagra-in-canada/ us approved canadian pharmacy thesis standard format click here essay importance of work viagra intercourse duration uni essay follow url free 1000 word essay on army values belonging creative writing hsc in the holidays clomid for ed essays on jinnah cipro and staph https://www.carrollkennelclub.org/phrasing/physics-reaction-paper/6/ click here leader essay https://bigsurlandtrust.org/care/cialis-30-day-price/20/ research papers global warming help homework online search donde se puede conseguir cytotec en sps follow url top mba essay ghostwriting services gb https://elkhartcivictheatre.org/proposal/book-review-blogs/3/ essay contest for 2006 follow url go site https://servingourchildrendc.org/format/limitation-of-operation-research/28/ essay questions about internet ciprager 20 mg cialis cheap prescription viagra dissertations + women + educational leadership t-Button t-Button–small t-Button–danger t-Button–stretch to style the button for this example. However, if you want to style it in a different way, use the Oracle’s APEX Button Builder to quickly generate the code needed.

After you are done styling the button, change the column ERROR_CODE to a link type.

Modal Dialog Page

The next step will be to create a new blank modal dialog page. On that new page, create a new region with the type of Static Content, and add three items; ID (hidden), Item Description (display only), and Item Error (display only). This region type is highly customizable, so it will work for many different situations.

We can now head back to our Error Code column on the previous page and direct that link to our new modal dialog error page, sending it the item’s ID, description and error. Now we have a styled button that, when clicked, opens a new modal dialog page and shows the full details of a column that Users would struggle to read in an Interactive Grid column.

Requirements

  • Oracle APEX 18x+

Learn More