Home/Questions/Q 3888
In Process
Ankita
Ankita

Ankita

View Profile
  • 0
Contributor
Asked: 2020-12-02T19:27:26+05:30

Put colour in columns particular text based on condition

  • 0

In reports one column there are two values payload and error,i want to heighligh only error with red colour if possible that row as well.How to achieve this in oracle apex

question

    4 Answers

    1. Vinish

      Vinish

      View Profile
      Legendary

      Take one more column in your SQL query to highlight the column. Below is an example:

      Select 
payload, error,
case when error = 'INACTIVE' then
'red'
else
''
end bgcolor 
From YourTable;

      Now in the HTML expression of ERROR column, specify the span tag as follows:

      <span style="background-color: #BGCOLOR#;">#ERROR#</span>
      • 0
    2. Ankita

      Ankita

      View Profile
      Contributor

      Is it possible to show in one column only?because the requirement is such that payload and error should be in same column

       

      • 0
    3. Timo Herwix

      Timo Herwix

      • Germany
      View Profile
      Contributor

      maybe this solution will help you ->

      https://tm-apex.blogspot.com/2020/08/highlight-cells-based-on-value.html?m=1

      you don‘t need HTML expressions which is very helpful in some cases.

       

       

      • 0

    You must login to add an answer.