Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
โžก๏ธ Get answers for your development issues
โžก๏ธ Help others
โžก๏ธ Write an article
โžก๏ธ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses
Rory
Rory

Rory

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 27 Points
View Profile
  • 2
RoryContributor
Asked: September 19, 20202020-09-19T20:47:04+05:30 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
  • 915
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

    1 Answer

    1. Vinish

      Vinish

      • 1 Question
      • 847 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2020-09-20T04:59:49+05:30Added an answer on September 20, 2020 at 4:59 am

      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
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Tutorial

    Recent Blog Posts

    • Vinish

      What is Oracle ERP?

    • Vinish

      The Benefits of Unit Testing

    • Vinish

      Java OOPS Concepts MCQ Quiz

    • Vinish

      What is the Best Database to Use?

    • Vinish

      Sending Query Strings in Post Requests in C#

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • Image to Base64
    • PL/SQL Beautifier

    Creative Commons License
    This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
    © 2021 OrclQA.Com. All Rights Reserved.
    Privacy Policy - About Us