Default Sort order of tickets

[Amphicar770]

Script URL:
Version of script:
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
sort
Write your message below:

Hello,

How do I change the default order so that newest tickets show first instead of oldest tickets. I did do a search but the solve appears to be for an older version.

Thanks,

Mike

[Klemen]

Open file print_tickets.inc.php located inside "inc" folder in Notepad and change

Code: Select all

$sql .= ' ORDER BY `status` ASC, `priority`';

to

Code: Select all

$sql .= ' ORDER BY `lastchange` ';

This will sort the tickets by "Last updated" by default. If you wish to order them by date submitted by default try this instead:

Code: Select all

$sql .= ' ORDER BY `dt` ';

[scudd]

Hello, does this apply to the latest version? I cant see that line..

I''d like to sort them by the last update, descending..

[Klemen]

It should work with 2.2 too, but that code is now in the "prepare_ticket_search.inc.php" file.

I'm working on letting each staff choose their default sort order for future versions to avoid having to manually modify files.

[scudd]

many thanks..

[sloscheider]

I'd like to add that near the bottom of the file is a line like this:

$sql .= ' ASC ' ;

changing ASC to DESC in that line will change the sort from ASCending to DESCending - This seemed to do the trick for me but I don't know enough programming to say for sure it wont cause some other problem.

Thanks for the great product!

[Klemen]

Upgrade to version 2.3 - it supports selecting default settings for each individual user.

[Mazurizi]

Hello Klemen,

I hate to bump old threads - but could you give me instructions of how to set the default search order by user? I'm guessing it is in the settings section? Although I can't see an option that relates to it.

Running version 2.3.

Thanks.

[Klemen]

Hi,

On the admin main page scroll down to "Show tickets" and click "More options".

Select your desired sorting options, select the "Make this my default view" option and click "Show tickets".

This should remember your settings.

[Mazurizi]

Spot on Klemen, you're a legend.

Thanks for the prompt reply.