@markr in SuiteScript 1.0 you can use something like searchColumns = search[0].getAllColumns() to get all the columns from your search and then search[i].getValue(searchColumns[0]) to get the value from your first column, etc. I am not certain off the top of my head how to get the equivalent for SuiteScript 2.0.

hi

hello

I'm currently doing something like this:

for(var i = 0; i < arr_res.length; i++){
          var allcols = arr_res[i].getAllColumns();
          var allvals = new Array();
          for(var col = 0; col < allcols.length; col++){
               var lbl = allcols[col].getLabel();
               allvals.push(arr_res[i].getValue(lbl));
          }
// other code after I get values
}

I think this solution is better than the one I suggested.

okay so I shouldn't use the label

I would get the label for the first column, then the value, then push that to your array.

so would I be using arr_res[i].getValue(col) then?

arr_res[i].getValue(allcols[col]) is the right syntax

so, var lbl = allcols[col].getLabel(); and var value = arr_res[i].getValue(allcols[col]) as rustshackles stated

man talking stuff out makes things so much easier, that worked

excellent!

thanks guys, I thought my hair was gonna turn grey on this one for sure