Highlighted
Super Contributor.
Super Contributor.
1556 views

ESS Portal > View Open Requests sort issue

Hi Experts,

We have SM 9.51 PD installed on windows server.

Observed that on ESS Portal under View Open Requests menu old tickets are getting display OOB. We want latest tickets to be display under this however its coming from stored query we unable to sort this ticket based on latest ticket no or open datetime,. We tried Sort fields under stored query but no luck. Any other way to achive this.

Can anybody knows how to do this sorting either in stored query or any other way.

 

0 Likes
17 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Try this:

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Dear Experts,

Still no luck to achieve this. Need expert inputs.

Please help,

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Strange to know this is basic requirement whose correct solution/workaround still not available with anyone.... 😞

 

0 Likes
Highlighted
Trusted Contributor.
Trusted Contributor.

Step 1: Create a new field 'negtivedatestamp' - datatype 'datetime' in incidents file

Step 2: Create a macro (type: Evaluate Expressions) - Applies: Interaction Records are Saved

Step3: Set parameters/Expressions to evaluate to : negativedatestamp in $L.new='12/31/9999 19:00:00' - tod()** the 'negativedatestamp' will give return the negative datestamp

Step 4: in the stored query you can specify the 'sortby' field be 'negativedatestamp'.

Step 5: logout / logback in. When you click on 'View open'/ 'View closed' requests in ESS you will see the latest/recent request on top.

Let me know if you have any questions or need any more information.

Thanks!

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Thanks skairuppala,

Have tried your steps but stuck at step 3 where im trying to keep below suggested condition (dateformat we kept in SM as dd/mm/yyyy)

sortdatestamp in $L.new='31/12/9999 19:00:00' - tod()

However its not keeping condition as it is and setting automatically condition as (sortdatestamp in $L.new=tod()), See attached screenshot for it.

Can you please suggest about this condition is valid or not.

0 Likes
Highlighted
Trusted Contributor.
Trusted Contributor.

Interesting..  the statement looks ok. You may want to check the output/value of the 'sortdatestamp'

Also, Try

1. add  a macro condition - null(sortdatestamp in $L.new) then restart the application & web

2. then , try to check if you see a valid date when you execute your statement in RAD.

sortdatestamp in $L.new='31/12/9999 19:00:00' - tod()

hope above helps.,

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.