[SOLVED] OrderBy not working in overview

Moderator: crythias

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

[SOLVED] OrderBy not working in overview

Postby S1lv3rW1z4rd » 28 Dec 2017, 11:31

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 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

root
Moderator
Posts: 1079
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: OrderBy not working in overview

Postby root » 28 Dec 2017, 12:21

Hi,

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

- Roy
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

You need professional services? Check out http://znuny.com/

jojo
Moderator
Posts: 14088
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: OrderBy not working in overview

Postby jojo » 28 Dec 2017, 12:28

Wrong Sysconfig Setting
"Production": OTRS Business Solution™ 6, STORM powered by OTRS
"Testing": OTRS git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 28 Dec 2017, 12:38

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 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

root
Moderator
Posts: 1079
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: OrderBy not working in overview

Postby root » 28 Dec 2017, 13:12

Hi,

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

- Roy
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

You need professional services? Check out http://znuny.com/

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 28 Dec 2017, 13:39

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 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

root
Moderator
Posts: 1079
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: OrderBy not working in overview

Postby root » 28 Dec 2017, 14:03

Hi,

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

- Roy
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

You need professional services? Check out http://znuny.com/

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 28 Dec 2017, 14:08

Awesome !
That works, Thanks a lot for your quick reply !
Running OTRS 6 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

marcelwuestner
OTRS newbie
Posts: 9
Joined: 02 Jun 2016, 10:00
OTRS Version?: 5.0.9
Real Name: Marcel Wüstner
Company: Stadtwerke Rosenheim GmbH & Co. KG

Re: OrderBy not working in overview

Postby marcelwuestner » 08 Jan 2018, 12:35

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
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 08 Jan 2018, 13:50

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 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

Drak0
OTRS newbie
Posts: 2
Joined: 26 Mar 2015, 15:37
OTRS Version?: 6.0.3

Re: OrderBy not working in overview

Postby Drak0 » 10 Jan 2018, 07:59

same problem here, after automatic refresh the oldest ticket is on top

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 16 Jan 2018, 08:55

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 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

zzz
OTRS wizard
Posts: 129
Joined: 15 Dec 2016, 15:13
OTRS Version?: 3.x - 6.0.x
Real Name: Emin Yazi

Re: OrderBy not working in overview

Postby zzz » 16 Jan 2018, 09:20

Hello,

this could/should be fixed in the upcoming 6.0.4.

Best regards

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 18 Jan 2018, 12:39

Thanks, I see in the release notes of 6.0.4 this is indeed fixed.
Will update soon.
Running OTRS 6 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2

S1lv3rW1z4rd
OTRS newbie
Posts: 21
Joined: 10 Oct 2017, 13:45
OTRS Version?: 6.0.4

Re: OrderBy not working in overview

Postby S1lv3rW1z4rd » 19 Jan 2018, 17:35

I can confirm the update to 6.0.4 fixes the issue.
Running OTRS 6 Free (6.0.4) on CentOS 7.4/MYSQL/Apache2


Return to “Help”

Who is online

Users browsing this forum: coolmf and 3 guests