Multi row variables sorting in descending order

[Madhusagar Pal1]

Hi Team,

Need help, regarding Multirow variable set.

I have scenario, in the Multirow variable set "status date" variable should be sorting in descending order. How can we achieve without scripting. 

Thanks 

[SD_Chandan]

Hi @Madhusagar Pal1 ,

we can achieve with catalog client script.

function onLoad() {
var mrvsName = 'your_mrvs_internal_name';
var mrvsData = JSON.parse(g_form.getValue(mrvsName));
if (mrvsData && mrvsData. length > 0) {
mrvsData.sort(function(a, b) {
var dateA = new Date(a.status_date);
var dateB = new Date(b.status_date);
return dateB - dateA;

});
g_form.setValue(mrvsName, JSON.stringify(mrvsData));

}
}

[sanjay02]

Hi @Madhusagar Pal1 ,

If your MRVS pulls from a data from table

you can achieve this like mentioned below :

1.Open the variable configuration inside the MRVS.

2.Add this under Variable Attributes:

order_by_desc=status_date

[kaushal_snow]

@Madhusagar Pal1 ,

CHECK THIS: https://www.servicenow.com/community/itsm-forum/sorting-a-multi-row-variable-set/m-p/684225

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Ankur Bawiskar]

@Madhusagar Pal1 

when should this run and sort?

On RITM form when variable editor shows MRVS?

OR

As soon as row is added in MRVS during submission?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏