Multi Row Variable Set Sorting

[patbishop]

I have a requirement to sort the contents of a Multi-Row Variable Set by a specific column.

I didn't happen to see an order on the 'sc_multi_row_question_answer' table. I'm weary of attempting to update the "row_index" field as I'm not sure of the way it's being generated. Regardless, SN somehow knows the order. 

[Ankur Bawiskar]

Hi,

what approach you are trying to check? you mentioned some row_index approach

Regards
Ankur

[patbishop]

It certainly appears that the row_index field controls the sorting. I'm not sure exactly that value is generated. It appears to be some sort of Timestamp or Hash. 

[patbishop · Accepted solution]

I actually just went to the MRVS table, and changed the row_index to 1, 2,3,4,5 etc and was successfully able to adjust the sorting.  I'm not sure if there's any repercussions on changing the row_index though. 

[Ankur Bawiskar]

@patbishop 

Is there any update on this? Is this question got resolved or you need some more assistance.

Somebody has take time & efforts to help you; so please check this.

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

Regards
Ankur