Open Closed

How to export more then 1000 rows #10487


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)
  • 0
    musa.demir created
    Support Team

    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?

  • 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

  • 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.