How do you sort within the Simple List Widget

[zag]

HI guys, 

I am trying to get the Simple List Widget to sort properly.  My Display field is Short Description, the Secondary Field is u_trending_status, number

What ends up coming out is an Ascending Sort by Short Description.  I thought the first Secondary Field was the Sort field. Anyone know whats going on?

[Chander Bhusha1]

Hi Zag,

Its controlled by the OrderBy field from the Widget instance. By default the Order by field is empty when you add the list widget to page. 

So you have to update the orderby field of the widget instance belonging to the simple list widget as mention in the below link:

Reference link will help you:

https://community.servicenow.com/community?id=community_question&sys_id=00f0dba9dbdcdbc01dcaf3231f96...

Mark helpful and correct if it helps.

Thanks,

CB

[zag]

Well now I am really confused. The reference link you attached looks nothing like my Simple list Instance Option

See Attached. 

[Chander Bhusha1 · Accepted solution]

Hi Zag,

Can you open  sp_instance_vlist.LIST.    This table hold the simple list widget isntance open the record for which you have created a simple list.

Bring the Order by field on the from using configure - form layout.

Open the list:

Search with the table for which you have crated the list.

Open the from: Configure form layout -- bring order by field on the form.

and update the field to which you want the order.

mark helpful and correct if it helps

Thanks,

CB

[zag]

Yup that did it, but I found an easier way to get to the screen. 

 Control Right Click on the object, select Instance Option, then from the top left hamburger icon [ 3 lines] left click and select Open In Platform .  You get then get to Configure / Form Layout in the same way. 

Thanks for your help!!!