Display Image based on Column Value with Interactive Report in Oracle APEX

-
This post demonstrate the steps to display image based on the column value in the table with Interactive Report in Oracle APEX.


Simple Report:
 
Instead of Patient Risk value we need to get as shown below
Steps: 1    I have created a table as shown below.
      CREATE TABLE "DEMO_PATIENT"
      (   
        "PATIENT_ID" NUMBER(5,0) NOT NULL ENABLE,
        "PATIENT_NAME" VARCHAR2(50) NOT NULL ENABLE,
        "PATIENT_RISK" VARCHAR2(10) NOT NULL ENABLE,
   CONSTRAINT "DEMO_PATIENT_PK" PRIMARY KEY ("PATIENT_ID")ENABLE
       )
    /
In Above table Patient_Risk column can contain only two possible values. 1. High  2. Low 
So based on these values we will show images.
Step2:  Create a Report in your APEX Application 
                    
Step3: Type following query to get data.
 
Step4: Hide icon and icon_color columns
 
Step5: Go to Patient_Risk Column properties and set following value under HTML Expression.
<span class="#ICON#" style="color: #ICON_COLOR#"></span> 

 

=======================================================


Following could be another option
Change the query as shown below
 
Now hide risk_icon and risk_color column as we have done in last example.
Now select patient_Risk column and apply following code under HTML Expression


Output will look like 
 

Have a Happy Learning

Regards
Digvijaysinh Virpura
 
 

Comments

Post a Comment

Popular posts from this blog

Custom Authentication in Oracle APEX

-
Image
 Custom Authentication in Oracle APEX  This blog demonstrate the steps for Custom Authentication in Oracle APEX. Step1: We Need a table Login.      CREATE TABLE   "LOGIN"    (            "LOGIN_PK" NUMBER(7,0) NOT NULL ENABLE,                 "ENTITY_OWNER_FK" NUMBER(7,0) NOT NULL ENABLE,                 "ENTITY_FK" NUMBER(2,0) NOT NULL ENABLE,                 "USERNAME" VARCHAR2(20) NOT NULL ENABLE,                 "PASSWORD" VARCHAR2(20) NOT NULL ENABLE, "EMAIL" VARCHAR2(50),   CONSTRAINT "LOGIN_PK" PRIMARY KEY ("LOGIN_PK") ENABLE,         ...
Read more

"Navigating the Oracle APEX Frontier: A Transformative PhD Expedition"

-
Image
My five-year journey of pursuing a Ph.D. in Oracle APEX has been filled with both challenges and invaluable learning experiences. I decided to write this blog to share my insights and to help those who are considering a Ph.D. and are in search of a compelling research topic.   Where did the idea come from? It all started with a simple Online Test Application on a Local Area Network (LAN) using Oracle APEX . The idea of pursuing a Ph.D. in Oracle APEX first came to me in 2011-12.During that time, I developed an application to conduct online MCQ tests for students, designed to run on the LAN. Using a standard computer with minimal configuration, I installed Oracle APEX and set up the application so that students could access the MCQ test on the intranet, allowing us to generate results instantly. ...
Read more

Display Dynamic TextField in APEX based on Table Columns.(APEX_ITEM.TEXT)

-
Image
This blog will demonstrate steps to display TextField dynamically based on Table Columns in Classic Report and insert data into database. Oracle APEX has a large collection of API in which APEX_ITEM.TEXT is used in this example while if you want to explore in detail just click on following link. https://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_item.htm#AEAPI192 Step1: Create a Classic Report based on SQL Query. In this demo i have used a Emp table. So my query look like as follows.     select EMP.EMPNO as EMPNO,               EMP.ENAME as ENAME     from EMP EMP and Result will look like as shown in following figure. Now If we need to display a textbox against each employee name we need to add one dynamic APEX_ITEM.Text. So now our query will change as follows. select  EMP.ENAME as ENAME,    APEX_ITEM.TEXT(01,null,NULL,2,NULL,'Emp_Salary') AS Salary,    APEX_ITEM.HIDD...
Read more