Hi,
Ex: I have 10000 rows in record, and have to create user filer as Assigned to so for that i have to fetch the data from the record and need to show in user filter,
as we know we can get the 5000 rows at a time from record then at the time i will get only 5000 values but i need 10000 values based on that i can use union operation , i wil show only 50 to 100 user id in the assigned to user filter.
is there any best approach for this.
thanks!
Discussion posts and replies are publicly visible
How many distinct users do you expect?
If you skip Record user filters and create a separate UI to create filters on your own, you could use picker fields to not have to query all the users at once.
Thanks for response Stefan Helzle
we may have 100 user id as of now, but in feature it may increase.
if we want to achieve in record user filter, is there any alternative solution?
I would go with a separate UI, or just use the record search.
Why do you want to use record data as filter? anyways those users available in Appian, so as Stefan Helzle suggested, you can use user picker field for filter and apply filters on record. In future, if you add more users it will show all users.