[otrs] Sort by subject and demo's calander

8 Jun 2005

      Hi!I am new working with mysql and OTRS, this may sound stupid, how do I set 
sortby=subject
I tried to look into :

c:\Orts\otrs\Kenel\system\ticket.pm
Line 950
sub GetLockedTicketIDs {
my $Self = shift;
my %Param = @_;
# check needed stuff
if (!$Param{UserID}) {
$Self->{LogObject}->Log(Priority => 'error', Message => "Need UserID!");
return;
}
# db quote
foreach (keys %Param) {
$Param{$_} = $Self->{DBObject}->Quote($Param{$_});
}
my @ViewableTickets;
my @ViewableLocks = @{$Self->{ConfigObject}->Get('ViewableLocks')};
my $SQL = "SELECT ti.id " .
" FROM " .
" ticket ti, ticket_lock_type slt, queue sq, article a" .
" WHERE " .
" ti.user_id = $Param{UserID} " .
" AND ".
" slt.id = ti.ticket_lock_id " .
" AND ".
" sq.id = ti.queue_id".
" AND ".
" slt.name not in ( ${\(join ', ', @ViewableLocks)} ) ORDER BY ";
# sort by
if (!$Param{SortBy} || $Param{SortBy} =~ /^CreateTime$/i) {
$SQL .= "ti.create_time";
}
elsif ($Param{SortBy} =~ /^Queue$/i) {
$SQL .= " sq.name";
}
elsif ($Param{SortBy} =~ /^Subject$/i) {
$SQL .= " a.a_subject";
}

and
C:\otrs\otrs\Kernel\Modules\CustomerTicketOverview.pm

#
my @ViewableTickets = ();
$SQL = "SELECT st.id FROM " .
" ticket st, ticket_state tsd, queue q,article a, " .
$Self->{ConfigObject}->Get('DatabaseUserTable'). " u ".
" WHERE " .
" tsd.id = st.ticket_state_id " .
" AND " .
" st.user_id = u.". $Self->{ConfigObject}->Get('DatabaseUserTableUserID') .
" AND ".
" q.id = st.queue_id ".
" AND ".
" q.group_id IN ( ${\(join ', ', @GroupIDs)} ) ".
# " AND ".
#" a.ticket_id = '".$Self->{DBObject}->Quote($Self->{UserCustomerID})."'".
" AND ".
" st.customer_id = '".$Self->{DBObject}->Quote($Self->{UserCustomerID})."'".
$SQLExt.
" ORDER BY ";

if ($Self->{SortBy} eq 'Owner') {
$SQL .= "u.".$Self->{ConfigObject}->Get('DatabaseUserTableUser');
}
elsif ($Self->{SortBy} eq 'CustomerID') {
$SQL .= "st.customer_id";
}
# elsif ($Self->{SortBy} eq 'Subject') {
#$SQL .= "a.a_subject";
#}

Please offer me any guidence on sorting by subject. Also, I see the Demo 
Version have a Calender option, i wonder where can I obtain the demo version 
with that Calender thing Thanks.

Henry

[otrs] Sort by subject and demo's calander

Henry Chan