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!
			
			
									
						
										
						Limit in Search button (CSV,EXCEL)
Moderator: crythias
- 
				nedmaj
 - Znuny expert
 - Posts: 168
 - 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)
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.
			
			
									
						
							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
			
						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