asked on

Oracle APEX (Advanced) - Highlight row based on condition

I have this query on a classic report.

SELECT   w.vendor, w.qty, r.rec
    FROM (SELECT   vendor, SUM(ord) AS qty
              FROM wag where ship_date = :P0_DATE
          GROUP BY vendor) w,
         (SELECT   vendor, SUM(ord) AS rec
              FROM recinc where "sDATE" = :P0_DATE
          GROUP BY vendor) r
   WHERE w.vendor = r.vendor
ORDER BY vendor

Open in new window

That query gives me the results of the attached file,

I want to highlight rows where the "Ordered" and "Received" column do not match

12 and 12 would not be highlighted
12 and 10 would be highlighted.

I am looking for someone to walk me through the process, i have been researching for a couple of days now, refraining from coming on here and asking with no solution in sight.
compare.png

Sean Stuber

please don't pictures unless you have to

post text

futureDBA

ASKER

understood. apologies

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

futureDBA

ASKER

I followed you completely until "Column Formatting" HTML EXPRESSION... i cannot find this under column attributes.

I found it furthered down.

When i ENTERED #ORDERED# and ran the query,

i literally get #ORDERED# as a result, but what I can say is that for the columns that are suppose to be RED, they are.. just not with the value, literally with #ORDERED#

futureDBA

ASKER

I also didn't understand "
change ORDERED to RECEIVED and VENDOR_NAME for those columns"

futureDBA

ASKER

got it... thank you sir..

futureDBA

ASKER

perfect