Sorting of dashboard columns

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Sorting of dashboard columns

Post by aph »

How are columns sorted by default in dashlets?
For example I have the following settings in SysConfig, DashboardBackend###0100-TicketPendingReminder under Ticket -> Frontend::Agent::Dashboard
Unbenannt_72.PNG
Here, the column names are sorted alphabetically.
On dashboard however, I see the following
Unbenannt_74.PNG
Clicking on Settings (the toothed wheel!) one gets to see the following
Unbenannt_78.PNG
Here the columns are neither sorted alphabetically nor do they correspond to the order they are displayed on dashboard.
Can anyone explain how colum order on dashboard is determined by default? That is to say how is the visible columns order is determined?
Thanks a lot.
You do not have the required permissions to view the files attached to this post.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Sorting of dashboard columns

Post by crythias »

There are some static placements, but the ORDER BY DRAG & DROP should be a clue.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Sorting of dashboard columns

Post by aph »

Thanks a lot!
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Sorting of dashboard columns

Post by aph »

Since I wasn't able to elaborate my question, I'll use another example:
By default OTRS Dashboard shows following column order for 'New Tickets', i.e. column 1=TICKET#, column 2 = AGE and column 3 = TITLE
Unbenannt_88.PNG
However the settings for this dashlet are as follows: Column 1 = Age, column 2 = Title and column 3 = TicketNumber. This order does not correspond to the order shown on dashboard.
Unbenannt_86.PNG
The order in SysConfig under Ticket -> Frontend::Agent::Dashboard is alphabetical and does not correspond to the order shown on dashboard.
Unbenannt_90.PNG
I couldn't locate any .pm or .dtl which may define the 'New Tickets' dashlet. Thus, as far as I understand, the default order shown on dashboard is derived neither from dashlet settings nor from SysConfig. So where is the default order defined (column 1=TICKET#, column 2 = AGE and column 3 = TITLE )? Of course I see that there is an option to change the order of columns around using drag and drop, but that doesn't answer my question about the default order shown on dashboard.
You do not have the required permissions to view the files attached to this post.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked