Hello there,
I am using a!pickerfieldrecord function under search filters to return data. I am applying this on integer field where user can apply multiple filter like 123456,5746875,59867578695,948647 etc at a time.
I want to apply a condition while searching that, user should enter 9 digits or atleast 9 digits in order for the search to work.
How can i achieve that, i dont want to apply queryfilter as that is not helping the requirement.
Added sample code, please suggest if that can be customized!!
a!localVariables( local!number:{}, local!isLoanNoValid: if( len(local!number) < 9, true, false ), a!columnLayout( contents:{ a!pickerFieldRecords( label: "Number", labelPosition: "COLLAPSED", maxSelections: 10, /*placeholder: "Please enter 9 digits inorder to start search",*/ recordType:cons!PAA_record_type, value: local!number, validations: if(isnull(local!number), null, if(local!isLoanNoValid,"Please sprovide 9 digit number",{}) ), saveInto:{} ) } ) )
Discussion posts and replies are publicly visible
AFAIK this is not how a record picker field works - it will always start displaying matches basically whenever anything is entered.
Thank you for the response Mike,
I did figured it is not possible, just checking if anyone tried customizations around it. This filter is affecting the performance of entire UI as there are 1000s of records even if we start typing 12.. etc
Thanks anyway!!
Hi, I am not sure if you have tried custom picker field , but you can achieve your requirement using this . while configuring the rule for suggest function you can add a condition. your query will execute only when user types 9 characters. This way you can enhance your performance . I had worked on this kind of requirement long back. I think it can help you too.
we acually updated the code from custompickerfield to recordpicker since record picker is way faster than custompicker. For our requirement, RecordPicker is appropriate.