Hi Daniel,<br><br>Thanks for your answer,<br><br>More than me the ones who want to see the tickets are the people in charge of generating reports (it&#39;s an outsourced help desk so reports are the baseline for closing every period). In this particular case they want to see all interactions from a certain client and for thar matter they were trying to sort the AgentTicketStatusView by client number<br>

<br>As you said the database is my friend so I guess I will come with some queries using AdminSelectBox but I still wonder why they won&#39;t show them all under StatusView.<br><br>Thanks again,<br><br clear="all">Leonardo Certuche<br>


<br><br><div class="gmail_quote">On Wed, Jun 24, 2009 at 2:27 AM, Obee, Daniel <span dir="ltr">&lt;<a href="mailto:obee@myhammer.de">obee@myhammer.de</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">










<div link="blue" vlink="purple" lang="EN-US">

<div>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Hi Leonardo</span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Our system has reached the 1.000.000 th ticket lately and to be
honest I never felt the need to see _<i>all</i>_ closed tickets.</span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">If so, then the database is your friend. Here you can cluster
tickets by FreeTexts for example and so on.</span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Where and wherefore do you want to see them?</span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Greets</span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Daniel</span></p>

<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>

<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">

<p><b><span style="font-size: 10pt;" lang="DE">Von:</span></b><span style="font-size: 10pt;" lang="DE">
<a href="mailto:otrs-bounces@otrs.org" target="_blank">otrs-bounces@otrs.org</a> [mailto:<a href="mailto:otrs-bounces@otrs.org" target="_blank">otrs-bounces@otrs.org</a>] <b>Im Auftrag von </b>Leonardo
Certuche<br>
<b>Gesendet:</b> Mittwoch, 24. Juni 2009 02:41<br>
<b>An:</b> User questions and discussions about OTRS.<br>
<b>Betreff:</b> [otrs] more than 6000 closed tickets</span></p>

</div><div><div></div><div class="h5">

<p> </p>

<p>Hi there,<br>
<br>
Here&#39;s a question for the ones with large implementations of OTRS. One of the
environments I take care of have reached the 6000 closed tickets. Unfortunately
OTRS won&#39;t show them all -only the 6000 newest. I was doing my homework and the
research only led me to the following user&#39;s manual entry <a href="http://doc.otrs.org/2.4/en/html/c2632.html" target="_blank">http://doc.otrs.org/2.4/en/html/c2632.html</a>
in which they talk about performance but they won&#39;t mention anything about not
showing old tickets after the 6000 limit is reached.<br>
<br>
Has anyone faced this same situation? Any help is much appreciated!<br>
<br>
Greetings,<br>
<br clear="all">
Leonardo Certuche</p>

</div></div></div>

</div>


<br>---------------------------------------------------------------------<br>
OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br>
<br>
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!<br>
<a href="http://www.otrs.com/en/support/enterprise-subscription/" target="_blank">http://www.otrs.com/en/support/enterprise-subscription/</a><br></blockquote></div><br>