Sorting tickets by ID

RT Users
1

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

2

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

The rt-users Archives

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: Careers — Best Practical Solutions

Best regards, Ruslan.

3

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

4

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

The rt-users Archives

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: Careers — Best Practical Solutions

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati