How to maximize limit of records in lookup selectbox variable

[Himanshi3]

Hi,

I am using a lookup select box variable in a catalog item to display User id from user table. I can't use Reference variable instead of lookup select box as User table has display field as "Name" instead of "User id". Also, I can't change the display field from name to user id since it will globally affect all other modules.

However, lookup selectbox variable is not showing all the records from user table and showing limited number of user ids. It might be due to large size of user data. Also, when I search with user id, it is not searching as it is containing limited number of user ids.

Please suggest which approach should be followed here to display all the records in lookup select box.

Thanks.

[Ankur Bawiskar]

Hi,

the max limit is 10000

it is set with that value keeping system performance in mind.

you cannot increase that.

Regards
Ankur

[Himanshi3]

Thanks for response Ankur. Where is this max limit stored? If we can't change max limit, is there any other approach we can follow to display all the records using lookup select box? 

[Ankur Bawiskar]

@Himanshi 

As per docs you cannot add more than 10,000 choices

NOTE : Even if you achieve to get more than 10K records via Lookup table then also after sometime it will throw performance issue , if the table you are referring to has very large data

So best way to handle this is to filter the data you need as per condition needed in advance qualifier.

Regards
Ankur

[Ankur Bawiskar]

@Himanshi 

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

If not, please let us know if you need some more assistance.

Regards
Ankur