Skip to main content
S
sureshs276515
March 28, 2025
Question

best way to get 10000 rows from records for user filter

  • March 28, 2025
  • 4 replies
  • 0 views

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! 

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    March 28, 2025

    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.

    S
    sureshs276515Author
    March 28, 2025

    Thanks for response [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

    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? 

    stefanhelzle0001
    stefanhelzle0001
    March 28, 2025

    I would go with a separate UI, or just use the record search.

    S
    shivakanthreddyp0001
    March 30, 2025

    Why do you want to use record data as filter? anyways those users available in Appian, so as [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 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.

    Terms & ConditionsAccessibility statement