Sort the ticket list by creation date in ascending order (695 Views)
Reply
Trusted Contributor
SanjeevDas
Posts: 387
Registered: ‎06-17-2013
Message 1 of 8 (695 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.

Trusted Contributor
SanjeevDas
Posts: 387
Registered: ‎06-17-2013
Message 2 of 8 (683 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.

Honored Contributor
Piku
Posts: 4,128
Registered: ‎06-17-2010
Message 3 of 8 (680 Views)

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

try using,

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/How-to-sort-certain-column-for-qbe-form-desc...

hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Trusted Contributor
SanjeevDas
Posts: 387
Registered: ‎06-17-2013
Message 4 of 8 (673 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

 

Honored Contributor
Piku
Posts: 4,128
Registered: ‎06-17-2010
Message 5 of 8 (662 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 .
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Trusted Contributor
SanjeevDas
Posts: 387
Registered: ‎06-17-2013
Message 6 of 8 (654 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

Honored Contributor
Piku
Posts: 4,128
Registered: ‎06-17-2010
Message 7 of 8 (645 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,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Trusted Contributor
SanjeevDas
Posts: 387
Registered: ‎06-17-2013
Message 8 of 8 (614 Views)

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

Thanks Piku, for your help.

 

Sanjeev

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.