dropdown search box find incorrect values

Question

Hi, 
 
 I am using a dropdown with values retrieved from a record. The record only has the identifier field and a text field. The issue is that when using the search option, it finds values that do not match exactly what is typed in the dropdown search box. 
 For example, I type part of the name of one of the records (" real ") and it correctly shows only one matching result, "LO REAL EUROPE SUCURSAL ENESPA&Ntilde;A." However, if I add one more letter ("real d "), the results change and show two results that do not exactly match what I am looking for: "INDUSTRIA CORE ESPA&Ntilde;OLA DE MODA" and "NEW ERA REMARK LIMITED". I understand that it shows these values due to the following, 
 "INDUSTRIA CO RE ESP A &Ntilde;O L A DE MO D A" and "NEW ERA RE M A RK L IMITE D ". If I add an "a" -> "reald a ", it only shows "INDUSTRIA CO RE ESP A &Ntilde;O L A DE MO DA ". 
 Isn't there a way for it to search only for results that exactly contain what I am typing? 
 Thank you very much.

JayaPrakash Ravipati · Answer

Hi alejandrov0003 , 
 You can try with custom picker field. It will solve your issue. 
 
 rule!TR_Test() 
 a!localVariables(
 local!data: {
 "LOREAL EUROPE SUCURSAL ENESPA&#209;A.",
 "INDUSTRIA CORE ESPA&#209;OLA DE MODA",
 "NEW ERA REMARK LIMITED",
 
 },
 local!result: if(
 a!isNotNullOrEmpty(ri!txt),
 where(
 a!forEach(
 items: local!data,
 expression: search(ri!txt, fv!item)
 )
 ),
 ""
 ),
 local!outdata: index(local!data, local!result, null),
 a!dataSubset(
 data: local!outdata,
 identifiers: local!data
 ),
 
) 
 a!localVariables(
 local!value,
 {
 a!pickerFieldCustom(
 label: "Custom Picker",
 labelPosition: "ABOVE",
 placeholder: "search",
 suggestFunction:rule!TR_Test(txt: _,),
 selectedLabels: local!value,
 value: local!value,
 saveInto: local!value,
 validations: {}
 )
 }
)

dropdown search box find incorrect values

Top Replies