Unable to display more than 10000 records in lookup selectbox

[Prem13]

I created a Lookup select box, it displays only 10000 records , there are more than 10k records

i doesnt want to use reference field since i need to display the userid from the sys_user table(and i even doesnt want to change at the sys_user table level too)

can anyone suggest how can i display sys_user records on displaying the userid of the users

[DrewW]

Last I checked a lookup select only displayed like 50 records and you have to use the search to see others.

Can you provide a screen shot of what you are talking about?

[Prem13]

Hi Drew,

there are millions of records in sys_user table, i need to display the list of users which should display the userid 

you can check the below screenshot on how i configured the lookup select box

Right now it displays only 10000 userid.

whats the best way to display all the users records, i need to search the user based on the userid

[Ct111]

You can configure the options which you want to see on reference variable...

like suppose you want to see only userid and name then that can also be possible like putting the below value in dictionary attribute of that reference variable.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_id;user_name

NOTE : Even if let's say 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 it to filter the data you need as per condition needed in advance qualifier.

Examples of cases where Lookup has caused issues

https://community.servicenow.com/community?id=community_question&sys_id=53fb0725db9cdbc01dcaf3231f96...

Mark my ANSWER as CORRECT and HELPFUL if it helps