Sort the ticket list by creation date in ascending order (441 Views)
Reply
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 1 of 8 (441 Views)
Accepted Solution

Sort the ticket list by creation date in ascending order

Hi Experts,

 

How do I sort the tickets in the list by date in ascending order permanently?

For example, when the ess users search the Open Request list, the users have to scroll down the list to see the current ticket. I want the current ticket to display at the top of the list.

i.e. sort the tickets by creation date in ascending order.

 

Thanks and regards,

Sanjeev.

Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 2 of 8 (429 Views)

Re: Sort the ticket list by creation date in ascending order

[ Edited ]

Hi Experts,

 

I have edited the sql query for the ess.SD.open page as shown below.

 

Untitled.jpg

 

Defined the Sort Fields with "open.time". The ticket got sorted by date but in ascending order. I want the ticket to sort in descending order(i.e. newly created ticket should be at the top pf the list). What value should I define in the Sort field so that the list shows the ticket in descending order sorted by open date?

 

Please help.

 

Thanks and regards,

Sanjeev.

Please use plain text.
Honored Contributor
Piku
Posts: 3,810
Registered: ‎06-17-2010
Message 3 of 8 (426 Views)

Re: Sort the ticket list by creation date in ascending order

Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 4 of 8 (419 Views)

Re: Sort the ticket list by creation date in ascending order

Hi Piku,

 

Thanks for the above link but it didnt help me much. Where should I go to edit the cc.search?

 

Sanjeev

 

Please use plain text.
Honored Contributor
Piku
Posts: 3,810
Registered: ‎06-17-2010
Message 5 of 8 (408 Views)

Re: Sort the ticket list by creation date in ascending order

in the cc.search process's Final Expressions.
You have to search the 'Process' records for name cc.search .
Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 6 of 8 (400 Views)

Re: Sort the ticket list by creation date in ascending order

Hi Piku,

 

I have found the cc.search

 

Untitled.jpg

 

But what shall I edit?

 

Regards,

Sanjeev

Please use plain text.
Honored Contributor
Piku
Posts: 3,810
Registered: ‎06-17-2010
Message 7 of 8 (391 Views)

Re: Sort the ticket list by creation date in ascending order

Hi,

You are in FD, you have to type
db in command line then search for Process-> cc.search. Here in cc.search process's Final Expressions put requires calculations.

hth,
Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 8 of 8 (360 Views)

Re: Sort the ticket list by creation date in ascending order

Thanks Piku, for your help.

 

Sanjeev

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation