Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
How can we display more than 5000 records in interface and search by custom picker?
Anyone having Idea?
Discussion posts and replies are publicly visible
You cannot query all 5000 records at once since it will lead to performance issues and the query will time out. You can try to query the data in batches of 10 or 20. And showing all 5000 records at once will not be looking good as well from UI point of view.You can query the data once some value is entered in the custom picker which can be used as a filter.
I'm using pagination and showing 10 records per page , but in my data table having more than 5k records, how can I display or shown under search 5001th record ?
On what basis will the 5001th record will be displayed?If its based on the value entered on the custom picker, just pass it as filter to the query then it will work similar to what you have implemented. You dont need to worry about anything else. The pagination and other things will take care. Whatever is matching that picker value, will get displayed in the first 10 rows. If its more than 10, it will be in the next page which will get queried when you move to the next page.