is there a way to order sublists on a transaction ...
# suitescriptn
Nicolas Bean
08/22/2021, 1:25 AMis there a way to order sublists on a transaction via scuitescript?
I have a map/reduce and I'm using the reduce phase -> in the map the search results are in the correct order but when I write those results to a sublist on a transaction (SO) it reorders them.. how do I keep the original order?
Nicolas Bean
08/22/2021, 1:36 AM@battk
b
battk
08/22/2021, 4:59 AMrunning things in order is not usually a strength of parallel scripts
battk
08/22/2021, 5:04 AMprobably best to number your search results so you can sort them later
n
Nicolas Bean
08/22/2021, 11:58 AMgood call, how do I number the search results?
Nicolas Bean
08/22/2021, 12:45 PMI'm basically creating my key & values and passing the results to the reduce phase.. would you recommend having a column in the SS be part of the values and then somehow sorting with that?
Nicolas Bean
08/22/2021, 12:53 PMwhats strange is that I added formula(numeric): rownum to see what the row numbers were... they are all jumbled up and don't seem to take my sorting into consideration (the results are actually sorted the way I want them.. but somehow the rownum are all messed up)
b
battk
08/22/2021, 9:55 PMdepends on how you have ordered your columns and how easy it is to assign numbers to them
battk
08/22/2021, 9:56 PMif you want to go the analytic route, you can use ROW_NUMBER
battk
08/22/2021, 9:56 PMsorting in your reduce code can work too
n
Nicolas Bean
08/23/2021, 8:00 PMok thanks @battk I did a not very elegant sorting using for loops