Open Table with Sort

gatesjj2
Tera Contributor

Hello,

I am attempting to modify a module to load a table sorted by item number in ascending order to enhance performance. Despite setting the link type to URL and configuring the arguments, the module continues to use user preferences to load the vulnerable items table, rather than the arguments that I set. Could someone assist me with this configuration?

 

Thank you!

1 ACCEPTED SOLUTION

Chaitanya ILCR
Kilo Patron

Hi @gatesjj2 ,

try this

put this in the arugments

sn_vul_vulnerable_item_list.do?sysparm_query=active=true^ORDERBYnumber

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

View solution in original post

2 REPLIES 2

Chaitanya ILCR
Kilo Patron

Hi @gatesjj2 ,

try this

put this in the arugments

sn_vul_vulnerable_item_list.do?sysparm_query=active=true^ORDERBYnumber

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

AshishKM
Kilo Patron
Kilo Patron

Hi @gatesjj2 ,

I check the similar link and found when we applying ORDERBY with other filter condition, there is no "^" sign for AND condition ( & for AND for filter ) , You can try to create the URL in list view and copy that link in "Link Type" and test.

 

OR  you can add below sys param for order direction.

 

&sysparm_order=number&sysparm_order_direction=asc

 

Example : on Incident table

https://devAAA.service-now.com/incident_list.do?sysparm_query=active%3Dtrue&sysparm_order=number&sysparm_order_direction=asc

 

-Thanks,

Ashish Mishra

https://www.linkedin.com/groups/13193330/ 

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution