Hi there,

We are currently trying to implement a dynamic dropdown lookup for a customer in the latest version of the Laserfiche client (10.2.1.953)

Due to the large dataset (~180000 rows) we have added the [SETTINGS]MaxDropDownLength attribute (currently set to 500) to a test user to allow the users to start typing in the address field and a 'Suggestion Box' should then bring up a list of the addresses in the SQL database. However, this doesn't seem to be working.

There is 180,00 rows in the database we are trying to query so I presumed that was the issue. I was able to narrow it down to the number 66154. With 66153 the 'Suggestion Box' appears for the user. Changing the raw value in row 66154 doesn't make any difference unfortunately.

Does anyone have any ideas why just one more row would make an otherwise well performing lookup just stop working if it has nothing to do with the data?