Skip to main content
Participating Frequently
Jun 8, 2023 1:35 PM UTC
Question

User Filter with more than 5000 rows

I am using expression to configure a user filter for my record. The expected result for the choices is more than 5000 but the record batch size has a max limit of 5000.  Is there a workaround?

4 replies

stefanhelzle0001
Brainy
Jun 8, 2023 1:39 PM UTC

What do you want to do with this massive data set? There is a reason for why Appian has this limits.

vernonpAuthor
Participating Frequently
Jun 8, 2023 1:47 PM UTC

Hi Stefan, is it possible to implement like a pickerfield  approach for the choices? 

stefanhelzle0001
Brainy
Jun 8, 2023 2:12 PM UTC

Sure. Follow the custom picker field example and make sure to query the data inside the suggest function.