[SOLVED] OrderBy not working in overview

Moderator: crythias

Post Reply
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

[SOLVED] OrderBy not working in overview

Post by S1lv3rW1z4rd »

Hi,

Since the new release 6 my dashboard is sorted with oldest tickets on top.

I searched the admin settings to change this and ended up here;

Image

But changing the SortBy field with either "Down" or "Up" doesn"t seem to change the order.
Am I missing something ?

Changes were successful deployed.
Last edited by S1lv3rW1z4rd on 19 Jan 2018, 17:36, edited 1 time in total.
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
root
Administrator
Posts: 3931
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: OrderBy not working in overview

Post by root »

Hi,

What do you expect by sorting the queue by age, what should the result looks like?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OrderBy not working in overview

Post by jojo »

Wrong Sysconfig Setting
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

Well default it now shows like this;

Image

When I press at Age at the top of the column it shows in reverse order like

Image

This is what I want it do by default.

When I refresh the oldest ticket is back at the top.

Which Sysconfig setting is wrong jojo ?
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
root
Administrator
Posts: 3931
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: OrderBy not working in overview

Post by root »

Hi,

The System Configuration you showed us (0270-TicketQueueOverview) does not match the screenshot (0120-TicketNew) of the result.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

Hi Roy,

Yes I'm aware but ticketnew doesn't have a sort property?
Where should I configure it ?

Image
Image

I tried to add a Sort field and fill in the properties and deployed without error;
But still no change;

Image
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
root
Administrator
Posts: 3931
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: OrderBy not working in overview

Post by root »

Hi,

Add SortBy and OrderBy to the Attributes parameter, separated by ;

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

Awesome !
That works, Thanks a lot for your quick reply !
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
marcelwuestner
Znuny newbie
Posts: 9
Joined: 02 Jun 2016, 10:00
Znuny Version: 5.0.9
Real Name: Marcel Wüstner
Company: Stadtwerke Rosenheim GmbH & Co. KG

Re: OrderBy not working in overview

Post by marcelwuestner »

I also have this problem and the solution from roy works for me as well.

But after the automated reload from the system, the tickets are sort by age with the oldest tickets on top.

What should I do?
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

Hi Marcel,

Good question I also have this behavior.
After a refresh the newest is back on top but this is kind of annoying indeed.
I haven't found the solution yet.
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
Drak0
Znuny newbie
Posts: 2
Joined: 26 Mar 2015, 15:37
Znuny Version: 6.0.3

Re: OrderBy not working in overview

Post by Drak0 »

same problem here, after automatic refresh the oldest ticket is on top
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

Does anyone know the solution ?

I would expect it to be this setting here but the sort is already set at Down instead of Up;

Image
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
zzz
Znuny superhero
Posts: 888
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: OrderBy not working in overview

Post by zzz »

Hello,

this could/should be fixed in the upcoming 6.0.4.

Best regards
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

Thanks, I see in the release notes of 6.0.4 this is indeed fixed.
Will update soon.
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
S1lv3rW1z4rd
Znuny newbie
Posts: 24
Joined: 10 Oct 2017, 13:45
Znuny Version: 6.0.30
Real Name: NB
Company: montova

Re: OrderBy not working in overview

Post by S1lv3rW1z4rd »

I can confirm the update to 6.0.4 fixes the issue.
Running OTRS 6 Community Edition (6.0.30) on CentOS 7.9/MYSQL/Apache2
Post Reply