Wednesday, June 8, 2011

Highlight Words in Standard Reports

After creating a plugin I received a lot of questions about how to enable column highlighting as shown in the following screen shot:

Column highlighting is not part of the plug-in. It is a built-in feature in APEX that has been around for a very long time. They're two ways to enable column highlighting in standard reports. The first is through the create report wizard. When you enable searching, as shown below, the columns that are selected to be searchable will automatically have column highlighting enabled on then.

To manually highlight a column edit the column. Scroll down to the Column Formatting region shown below. In the Highlight Words field you can enter a comma delimited list of words to search for or reference APEX items using the &ITEM_NAME. syntax. Note: for more on APEX variable syntax read this post.

7 comments:

  1. Nice post. I demonstrate it often in my training. Amazing how few people know of this feature.

    Regards,
    Learco

    ReplyDelete
  2. Can you help me? I need to know, How to use the future Highlight in Oracle Apex 4.0.2.0.7.

    Regards,
    Allan

    My google account allan.duenas@gmail.com

    ReplyDelete
  3. Nice article.
    Is there a way to specify in the Highlighting Words section to match all case-insensitive words?

    Best Regards,
    Alin

    ReplyDelete
  4. Hi Alin,

    you can modify the report query so that the filters are not case sensitive.

    Martin

    ReplyDelete
  5. Hi,

    The filter in my case is a text field in which users can write whatever they like. I don't have any control over this.
    The only solution would be either to be able to specify a case-insensitive search in apex, or a more complicated way would be to use javascript to manually highlight the items.

    Thanks,
    Alin

    ReplyDelete
  6. Hi Martin,
    Is there a way to change the coloring of the highlighted words?

    Thanks,
    Raoul

    ReplyDelete
    Replies
    1. Best bet is to inspect a highlighted word and see if it uses a CSS class. If so then just overwrite that class with the color of your choice.

      Delete