# SAIL I have custom picker field Manager. When user types is 3 characters

pallavis over 9 years ago

# SAIL
I have custom picker field Manager. When user types is 3 characters, I need to get list of users with first name or last name matching with 3 characters.
Since I have thousands of records in manager list, I dont want to get all in page load. I am making db call using query entity when user types in the field.
Able to pass reference of value using _ in SuggestFunction, but how to pass the same in SuggestLabel to retain the selected manager value?
I have attached my SAIL code below.

CustomPicker_Example.txt

Discussion posts and replies are publicly visible

0 GouthamKrishna over 9 years ago

If possible try using an expression/query rule which takes identifier and returns user name in format of FN+LN. I doubt you can use rule as reference in selectedLabels field.

Try this:

selectedLabels: if(
isnull(local!user),
null,
rule!someQuery(local!user)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pallavis over 9 years ago

@goutham...i tried this approach.....its working as expected...thank you !!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel