Limit in Search button (CSV,EXCEL)

Moderator: crythias

Post Reply
gecelann
Znuny expert
Posts: 164
Joined: 12 Feb 2016, 08:05
Znuny Version: 5.0.0
Real Name: ann
Company: rghdinc

Limit in Search button (CSV,EXCEL)

Post by gecelann »

Hi,

Good day!
I would like to ask if I can use more than 2000 in search limit in order to export it through csv or excel?

I already edited the Ticket::Frontend::AgentTicketSearch###SearchLimit in sysconfig with 200000
value. Is it possible to use it? Tried exporting it through csv but the loading of exporting takes too long and I didn't get the result of my search ticket.
Help me to maximize the use of search button please. thank you!
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: Limit in Search button (CSV,EXCEL)

Post by nedmaj »

Hi,

I use 100000 and it works just fine (query results returns in about 10 seconds depending on the criteria).

I would suggest you to verify your database performance.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Post Reply