Spotlight Search in Apex

 Spotlight Search in Apex

1) create .js file with 

function triggerSpotlight() {

$('#SPOTLIGHT').click();

}

2) Attached .js file to 

 for 5.1 

1. Go to Shared Components -> User Interface Attributes -> Desktop -> Javascript

for 18+ 

  1. Edit Application --> User Interface --> JavaScript 

1) Down load Spotlight Search Plug from (Apex.world)

2) Go to Page 0 (Global Page)

        

a) Create Dynamic Action on Click Event (Dynamic Action Tab)

True Action - > APEX Spotlight Search (PLUGIN)

Enable Keyboard Shortcuts = True

Keyboard Shortcuts = ctrl+k,command+k

Data Source SQL 

          SELECT nvl(b.lngdescr,b.descrlng)||'('||b.applname||'-'||b.pageno||')' AS title ,b.descrlng AS description, utl_url.unescape(apex_page.get_url(p_page => b.pageno,p_items => 'P0_APPLN,P0_DESCRLNG,P0_APPLNO,P0_REFAPPLN', p_values => B.APPLNAME||','||B.DESCRLNG||','||B.APPLNO||','|| (select descrlng from appln_mast i where i.applno=b.refapplno))) as link,ICON AS icon  FROM appln_mast b, application a

where A.APPLNAME=B.APPLNAME

AND a.USERNAME= v('APP_USER')

AND NVL(a.ROLE_INSERT,'N')='Y'

order by b.srno

3) Go to Shared Components --> Lists --> List --> Details Desktop Navigation Bar 

-> Create Entry 

Image/Class :fa-search

List Entry Label(Value Required) :Search...

Target type : URL

     URL Target : javascript:triggerSpotlight();