Rory
Rory

Rory

View Profile
  • 2
Contributor
Asked: 2020-09-19T20:47:04+05:30

Add strikethrough to deleted row in Interactive Grid or Interactive Report

  • 2

HI Vinish

I am new to APEX (using 19.2) and I find your blog to be a mine of amazing information. I love the way you describe in detail the steps to follow with clear examples.

I wonder if you can help? I know that you can set row highlighting on an IG and IR based on the value of a column in a row by using the format option in the actions dropdown.

I wonder if it is possible to show the row with strikethrough on each column when I delete the row?

What I mean is, if I use your example about deleting a row, say I just update an ACTIVE_IND column to be 'N'? I'd like to see the row still showing in the grid, just with each column value with a strikethrough - something similar to what you get out of the box with IG (but IG removes the row from the grid)

Any help is much appreciated.

Regards

Rory

strikethrough

    1 Answer

    1. Vinish

      Vinish

      View Profile
      Enlightened

      Hi Rory,

      Thank you so much.

      To make the column value strike-through, follow these steps:

      Take one more column LINETHROUGH, for your interactive report/grid query. Below is an example:

      select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
ACTIVE_IND,
case when active_ind = 'N' then
'text-decoration: line-through;'
else
''
end linethrough
from EMP

      If the ACTIVE_IND value is N, then it will apply the text-decoration: line-through; CSS.

      Make this column as a hidden column.

      Now for every column (EMPNO, ENAME, JOB, etc.) add the following HTML in HTML expression:

      <span style="#LINETHROUGH#">#EMPNO#</span>

      Change the column names accordingly.

      Below is the screenshot:

      Applying line through CSS to columns.

      Do this for every column, for example, for ENAME column:

      <span style="#LINETHROUGH#">#ENAME#</span>

      Now save the changes and run the report, you will get the output as shown below:

      IR report output.

      If you following that Delete button in IR report tutorial, just add one more action in it to Refresh the IR report region.

      To do this for the Interactive Grid report, follow these steps:

      Make the column type as HTML expression and add the expression as follows:

      <span style="&LINETHROUGH.">&ENAME.</span>

      For IG, specify the column between ampersand (&) and a dot (.) instead of hash(#), you can notice in the above HTML expression.

      Below is the screenshot:

      IG HTML expression example.

      Please try and let me know for any further questions.

      • 3

    You must login to add an answer.