Base solution for your next web application
Open Closed

How to export more then 1000 rows #10487


User avatar
0
SRTMDEV created

Prerequisites

  • What is your product version?
    • 8.6.0
  • What is your product type (Angular or MVC)?
    • Angular
  • What is product framework type (.net framework or .net core)?
    • .NET Core

Hello Team, We have requirment where we want to provide user to export more then 1000 rows but due to currently max. limit in platform we are unable to export. Can you guide us how we can achieve such type of scenario to export more then 1000 rows.

Thanks, JJ


3 Answer(s)
  • User Avatar
    0
    musa.demir created

    Hi @SRTMDEV

    It should not filter row count, it takes all and exports it. See:

    https://github.com/aspnetzero/aspnet-zero-core/blob/46aac958aa330771b37a3e4d5bc220d4e1221549/aspnet-core/src/MyCompanyName.AbpZeroTemplate.Application/Authorization/Users/UserAppService.cs#L120

    https://github.com/aspnetzero/aspnet-zero-core/blob/46aac958aa330771b37a3e4d5bc220d4e1221549/aspnet-core/src/MyCompanyName.AbpZeroTemplate.Application/Authorization/Users/UserAppService.cs#L420

    https://github.com/aspnetzero/aspnet-zero-core/blob/dev/aspnet-core/src/MyCompanyName.AbpZeroTemplate.Application/Authorization/Users/Exporting/UserListExcelExporter.cs

    Can you please check that if GetUsersFilteredQuery returns more then 1000 item?

  • User Avatar
    0
    SRTMDEV created

    Hello Team,

    I not asking for specific user services, my mean was to allow user to export more then 1000 rows mean allow end user to export data from any grid.

    Thanks, JJ

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @SRTMDEV

    You can simply send maxResultCount as 1000 or any number you want. But, we suggest you to create a new endpoint for excel export operation. You can take a look at GetUsersToExcel method of UserAppService class and implement a similar one for your need.