List component - Double sort on columns

[Esteban Aramendi]

Hi there, how are you?

 

A client would like to have a "List component" with several columns, in which they want to have a double sort, one for "Time Since Modified (Days)" and other for "Time Open (Days)", for which the first sort should be for tickets that has more days since the last modified and then, a second sort for the oldest tickets.

 

Maybe an image would be better, this is how they would like the grid

 

    

TKT Number	Time Since Modified (Days)	Time Open (Days)	Assignee
2	60	70	John
3	60	70	John
4	60	68	Sara
5	60	62	Sara
6	45	60	Elizabeth
1	32	90	Elizabeth
7	32	33	George
8	32	33	George
9	21	22	George

 

 

The thing is, that when I try to make a double sort editing the columns, even though I can add several Columns to the Sorting options, and selecting them the order that should be the sort, it doesn't work, it only uses the first option on the "Sorting"

 

 

Is it possible then to make a double sort? If so, how it would be? Am I missing some step here?

 

PS: The product is Xtraction (the one I'm trying to make the dashboard) connected to CA Service Desk Database.

 

Thanks for any help.

 

Regards

[Michael Mueller]

Sorry for coming back to you that late.

It might be related to the fact, that, at least, I have no idea for which product you are looking for an answer.

The screenshot is unfamiliar to me.

Let us know the related product , and a moderator will put this question into the right community, if the current "Service Management community" is the wrong one.

Regards

..........Michael

[Esteban Aramendi]

Hi Michael_Mueller, thanks for letting me know that "tiny" detail.

 

The product is Xtraction connected to CA Service Desk (I updated the main question).

 

Cheers