Sorting tickets by ID

We are looking to set our rt homepage to show tickets by id --> desc.

We think we found the right file at :
/opt/rt3/local/html/Elements/MyTickets

This shows the following content:

<& /Elements/TicketList,
Format => “’<a
href=”$RT::WebPath/Ticket/Display.html?id=id">id/TITLE:#’,
’<a
href="$RT::WebPath/Ticket/Display.html?id=id">Subject/TITL
E:Subject’, Priority, QueueName, ExtendedStatus",

    Query => $Query,
    OrderBy => 'Status',
    Order => 'DESC',

Order => ‘ASC’,

    Rows => $rows,
    ShowNavigation => 0
    &>

</&>

We changed OrderBy => ‘Status’, to OrderBy => ‘id’, but didn’t see the
sort results we thought we would. Do we need to use a different keyword
than ‘id’?

Thank you.

Chance Ervin
Intelenet Communications Inc.
OCP, SCSA, MCP
Systems Engineer

Most probably you want to clean mason cache to see changes.On 4/6/06, Chance Ervin cervin@intelenet.net wrote:

We are looking to set our rt homepage to show tickets by id --> desc.

We think we found the right file at :
/opt/rt3/local/html/Elements/MyTickets

This shows the following content:

<& /Elements/TicketList,
Format => “’<a
href=”$RT::WebPath/Ticket/Display.html?id=id">id/TITLE:#’,
’<a
href="$RT::WebPath/Ticket/Display.html?id=id">Subject/TITL
E:Subject’, Priority, QueueName, ExtendedStatus",

    Query => $Query,
    OrderBy => 'Status',
    Order => 'DESC',

Order => ‘ASC’,

    Rows => $rows,
    ShowNavigation => 0
    &>

</&>

We changed OrderBy => ‘Status’, to OrderBy => ‘id’, but didn’t see the
sort results we thought we would. Do we need to use a different keyword
than ‘id’?

Thank you.

Chance Ervin
Intelenet Communications Inc.
OCP, SCSA, MCP
Systems Engineer



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html

Best regards, Ruslan.

I asked about this a couple weeks ago, but didn’t see any responses.
So, I thought I would try again.

Chance Ervin
Intelenet Communications Inc.
OCP, SCSA, MCP
Systems Engineer-----Original Message-----
From: Chance Ervin
Sent: Thursday, April 06, 2006 10:54 AM
To: 'rt-users@lists.bestpractical.com’
Subject: Sorting tickets by ID

We are looking to set our rt homepage to show tickets by id --> desc.

We think we found the right file at :
/opt/rt3/local/html/Elements/MyTickets

This shows the following content:

<& /Elements/TicketList,
Format => “’<a
href=”$RT::WebPath/Ticket/Display.html?id=id">id/TITLE:#’,
’<a
href="$RT::WebPath/Ticket/Display.html?id=id">Subject/TITL
E:Subject’, Priority, QueueName, ExtendedStatus",

    Query => $Query,
    OrderBy => 'Status',
    Order => 'DESC',

Order => ‘ASC’,

    Rows => $rows,
    ShowNavigation => 0
    &>

</&>

We changed OrderBy => ‘Status’, to OrderBy => ‘id’, but didn’t see the
sort results we thought we would. Do we need to use a different keyword
than ‘id’? Or are we looking at the wrong file altogether?

Thank you.

Chance Ervin
Intelenet Communications Inc.
OCP, SCSA, MCP
Systems Engineer

Ruslan replied on the 11th. His advice sounds good since you make no
mention of anything besides changing the contents of the file.

Chance Ervin wrote:

I asked about this a couple weeks ago, but didn’t see any responses.
So, I thought I would try again.

Chance Ervin
Intelenet Communications Inc.
OCP, SCSA, MCP
Systems Engineer

-----Original Message-----
From: Chance Ervin
Sent: Thursday, April 06, 2006 10:54 AM
To: 'rt-users@lists.bestpractical.com’
Subject: Sorting tickets by ID

We are looking to set our rt homepage to show tickets by id --> desc.

We think we found the right file at :
/opt/rt3/local/html/Elements/MyTickets

This shows the following content:

<& /Elements/TicketList,
Format => “’<a
href=”$RT::WebPath/Ticket/Display.html?id=id">id/TITLE:#’,
’<a
href="$RT::WebPath/Ticket/Display.html?id=id">Subject/TITL
E:Subject’, Priority, QueueName, ExtendedStatus",

    Query => $Query,
    OrderBy => 'Status',
    Order => 'DESC',

Order => ‘ASC’,

    Rows => $rows,
    ShowNavigation => 0
    &>

</&>

We changed OrderBy => ‘Status’, to OrderBy => ‘id’, but didn’t see the
sort results we thought we would. Do we need to use a different keyword
than ‘id’? Or are we looking at the wrong file altogether?

Thank you.

Chance Ervin
Intelenet Communications Inc.
OCP, SCSA, MCP
Systems Engineer



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati