Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select List Plugin How to Highlight Search String

FofanaJun 1 2021 — edited Jun 1 2021

Hi, How can I highlight the Search Word in the Select List Plugin? Same way as the Autocomplete is doing it (See picture 2 below)
Unfortunately I cannot use autocomplete for the kind of request I have.
I tried to build the LOV myself adding the HTML code.
I was trying to achieve that by adding this in the below code but it is not rendered
v_query := replace(v_query, ''||:P23_CRM_CUST_AUTO||'','<b>'||:P23_CRM_CUST_AUTO||'</b>');

declare
	v_query nclob;
begin 	
    for rec in 
		(select name d, accountid r
		 from IOT_CRM_FETCHED_CUST
		)
	loop 
		v_query := v_query||'<option value="'||rec.r||'"'||(case when nvl(rec.r,'-1') = nvl(:P23_CRM_CUSTM_ID,'-1') then ' selected="selected" ' else null end)
		||'">'
		||rec.d||'</option>';                                     
	end loop;    v_query := replace(v_query, ''||:P23_CRM_CUST_AUTO||'','<b>'||:P23_CRM_CUST_AUTO||'</b>');	htp.prn(v_query);
end;

(edited)
image.png 
image.png

Sunday, May 30th

Comments
Post Details
Added on Jun 1 2021
0 comments
199 views