maximum number of records that are in a reference list query

[twooton]

glide.db.max_view_records - In the documentation it says "This property does not control the maximum number of records that appear in a list..." but what controls the limit on lists? I need something like sysparm_limit for the API but on a system level for a custom table and reference field.

My setup:
I have a custom table with 34k+ records
I have a reference field on the incident record pointing to this table
I have set up a global user preference to make the reference field autocomplete.contains
when I search I only get the records within the first 10,000 records.

Thanks

[Chuck Tomasi]

The number of records shown on any/all lists is controlled by the list setting. Here's an image from list v3 (lower right corner). It's stored as a user preference.

[twooton]

My apologies if I wasn't clear, I am not looking to set the number of choices displayed, the number of records that are queried is limited to the first 10,000 in the table and only those records are shown.

When I type into the reference field, I am only returning valid choices within the first 10,000 in the table, and not getting any beyond the first 10,000 in the table. My query should return dozens of results, however it only returns the first few. An example: I type in the word "Tennessee", within the first 10,000 records of the table, only 3 records contain that term. Within the entirety of the table, that should match more than 100 rows.  What is displayed is only the 3 records.

I am needing to increase the number of rows that the query looks at on the table so that it searches the entire table, not just the first 10,000 rows.

[Chuck Tomasi]

Have you set the property you mentioned above and what is the value at this time?

[twooton]

I currently have both of these set with no better result.

glide.db.max_view_records = 40000

glide.xmlhttp.excessive = 40000