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.
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.
Nice post. I demonstrate it often in my training. Amazing how few people know of this feature.
ReplyDeleteRegards,
Learco
Can you help me? I need to know, How to use the future Highlight in Oracle Apex 4.0.2.0.7.
ReplyDeleteRegards,
Allan
My google account allan.duenas@gmail.com
Nice article.
ReplyDeleteIs there a way to specify in the Highlighting Words section to match all case-insensitive words?
Best Regards,
Alin
Hi Alin,
ReplyDeleteyou can modify the report query so that the filters are not case sensitive.
Martin
Hi,
ReplyDeleteThe 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
Hi Martin,
ReplyDeleteIs there a way to change the coloring of the highlighted words?
Thanks,
Raoul
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.
DeleteHi Martin,
DeleteI did the inspect element of a highlighted word but it does not contain any CSS. Below is the code which I see:
" span style="font-weight: bold; color: red;"Test span Ignore this part "
Is there any way to add the custom class to this span?
Thanks,