How to increase "select lookup box" type limitations?

Community Alums
Not applicable

‎07-30-2020 03:29 AM

Hi,

In one of my catalog items variable, I am using a type "Select Lookup Box", which is referring to user table [Based on requirement.]. 

I have 50k+ active users record but select lookup box type is only allowing 10k choices in it as per the below screen shot. 

find_real_file.png

Please suggest me how can I increase the limitation on this variable?

Labels:
Preview file
10 KB
0 Helpfuls
  • 1,419 Views
7 REPLIES 7

Jaspal Singh
Mega Patron
Mega Patron

‎07-30-2020 03:35 AM

Hi Ganesh,

 

Is there any specific need to show it as Select box? Can't a field/variable of type reference be used?

 

0 Helpfuls

Community Alums
Not applicable
In response to Jaspal Singh

‎07-30-2020 05:34 AM

Actually my requirement is to display user name as well as email Id and user may enter user name or email Id to fill the variable value, so I am using select lookup box type but its displaying on 10k records!!!

0 Helpfuls

Jaspal Singh
Mega Patron
Mega Patron
In response to Community Alums

‎07-30-2020 06:00 AM

Hi Ganesh,

 

In that case you can use the dictionary attributes (ref_ac_columns) for the Reference field. So, either by Email or User name system will find match from the table refernced.

Refer link for a check.

0 Helpfuls

Community Alums
Not applicable
In response to Jaspal Singh

‎07-30-2020 06:24 AM

Hello,

The problem here is I need to search the user by using name only, I can't search with a email Id. One more thing, only name is going to display in the variable not email ID. 

I wanted to display name as well as email ID in the variable. 

Hope you got my point where I stuck

0 Helpfuls