Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Jun 1 2021
#html, #list, #select
0 comments
136 views