Dear all,
we have a question about the 'status view' page. In the top of the page it says 'Open Tickets : XX' and 'Closed Tickets : 10000'. Now is the closed ticket counter stopped with counting and we would like to now;
1. Is the OTRS database limit for tickets 10000 and is it like, i close ticket 10001 and ticket 00001 will be permenatly deleted.
2. The counter just can't go further then 10000
We would like to see the counter counts further and keep al our tickets, is that possible?
Thank you in advance.
Maximum Closed Tickets
Moderator: crythias
-
- Znuny newbie
- Posts: 2
- Joined: 09 Aug 2012, 09:31
- Znuny Version: 3.0.11
- Real Name: Nick van der Have
- Company: Hoogendoorn IT Services
Maximum Closed Tickets
You do not have the required permissions to view the files attached to this post.
-
- Znuny advanced
- Posts: 121
- Joined: 30 Aug 2011, 10:48
- Znuny Version: 3.3.8 && 4.0.9
- Real Name: Artjoms Petrovs
- Location: Latvia
Re: Maximum Closed Tickets
It is the ticket search limitation. Not so difficult to implement:
File Kernel/System/Ticket.pm approx line 3817: sub TicketSearch()
Please looka at that 10000 and make a conclusion
File Kernel/System/Ticket.pm approx line 3817: sub TicketSearch()
Code: Select all
...
my $OrderBy = $Param{OrderBy} || 'Down';
my $SortBy = $Param{SortBy} || 'Age';
my $Limit = $Param{Limit} || 10000;
...
Ar cieņu / Kind regards,
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
Re: Maximum Closed Tickets
for finding old tickets please use the search! It will cause severe performance issues if you try to display all old tickets in a screen
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny advanced
- Posts: 121
- Joined: 30 Aug 2011, 10:48
- Znuny Version: 3.3.8 && 4.0.9
- Real Name: Artjoms Petrovs
- Location: Latvia
Re: Maximum Closed Tickets
If we want to implement best practices, then it would even be advisable to use ticket archiving after each 5k tickets and keep the search limit low, but it is OP' s decision anyway!
Ar cieņu / Kind regards,
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
-
- Znuny newbie
- Posts: 2
- Joined: 09 Aug 2012, 09:31
- Znuny Version: 3.0.11
- Real Name: Nick van der Have
- Company: Hoogendoorn IT Services
Re: Maximum Closed Tickets
Thank you all for the replies. The most important thing is that al tickets are still there and all searchable.
Thanks for helping us out.
Thanks for helping us out.
Re: Maximum Closed Tickets
Hello, I am unclear on that number '10000' in the Closed Ticket view. Is that the search limit for closed tickets or the total number of closed tickets in the system? I have a test site setup as well and the numbers are different which leads to my initial question. On our live site, it reads 10000 but on our test site it reads 9348 which leads me to think it is the total number of closed tickets. However, when I ran a report of all closed tickets, that came up to 8164 which doesn't match up either. Could someone clarify what that closed number mean? Thanks.
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Maximum Closed Tickets
If the number of closed tickets in the system is lower than 10,000 then the "correct" number is shown. If the number of closed tickets in the system is higher than 10,000 then 10,000 is shown. It doesn't make sense to list *all* - lets say - 100,000 closed tickets. So the listing is limited to 10,000 closed tickets even though the other closed tickets are still in the system.
It's very rare that you want to search for a ticket that was closed a long time ago via status view. If you want to look at a very very old closed ticket you should use the ticket search.
It's very rare that you want to search for a ticket that was closed a long time ago via status view. If you want to look at a very very old closed ticket you should use the ticket search.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Maximum Closed Tickets
Thanks for clarification reneeb