How sort in portal

[yardenKrispel]

Hello, I need to sort the other column, which is called u_order, but the most important thing is in the portal!!! Please who can help me???

In this meter it is in the portal and you see the "other" so it should be below not above

[Saurabh Gupta]

Hi,
I think you are using incorrect attribute.
For the user reference variable below is the correct attribute for sorting by last_name.
 ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name,ref_ac_columns_search=true,ref_ac_order_by=last_name

Check the correct attribute to be used.
Dictionary attributes (servicenow.com)

[Saurabh Gupta]

@yardenKrispel 

C	If the provided solution meets your needs, kindly consider marking it as helpful and accepting it as the solution. This helps others who may have similar questions.

[SunilKumar_P]

Hi @yardenKrispel , 

In Service Portal, the reference variable list is sorted by the "Name" column rather than the "Order" column even if the table is sorted by Order field. 

Resolution

The reference list in Service Portal can be configured to be sorted by Order column using the following steps:

1. Navigate to the reference variable.
2. Go to the Type Specification section.
3. In the Variable Attributes field, add the following: ref_ac_order_by=order
4. Save and test on Service Portal. 

Ref. https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0743165

Regards,
Sunil

[Tai Vu]

Hi @yardenKrispel 

Check it out, same question as yours.

Sort fields in the record producer form in the portal

Put this line into your Variable Attributes.

ref_ac_order_by=u_order 

Ref: KB0743165 - In Service Portal, reference variable does not honor the "Order" column of the reference...

Cheers,

Tai Vu