Auto Suggest in Dynamic Lookup not working

Document ID : KB000097147
Last Modified Date : 18/05/2018
Show Technical Document Details
Issue:
We have noticed that the Auto Suggest feature in one of our Lookups in Projects does not work any more.
How can we get this working again?
Resolution:
You have to use an NSQL sql query structure in order for Auto Suggest feature to work.
Modify the query from:

select r.UNIQUE_NAME, r.FULL_NAME, r.first_name, r.last_name 
from CMN_SEC_GROUPS g 
join CMN_SEC_USER_GROUPS ug on (g.ID=ug.GROUP_ID) 
join SRM_RESOURCES r on (ug.USER_ID=r.USER_ID) 
where g.GROUP_CODE ='DSV_prj_exec' AND @FILTER@ 

TO: 

select 
@SELECT:r.UNIQUE_NAME:UNIQUE_NAME@, 
@SELECT:r.FULL_NAME:FULL_NAME@, 
@SELECT:r.first_name:first_name@, 
@SELECT:r.last_name:last_name@ 
from CMN_SEC_GROUPS g 
join CMN_SEC_USER_GROUPS ug on (g.ID=ug.GROUP_ID) 
join SRM_RESOURCES r on (ug.USER_ID=r.USER_ID) 
where g.GROUP_CODE ='DSV_prj_exec' AND @FILTER@