I have a script that load a saved search it read the column 0, which is the SO, and it return the SO #. It's all fine. However if the Saved search is changed and the first colums is the city, the script is going crazy. Instead of using the Column Number I would like to user the Name of the column. I tried this but it did not work log.debug(' ','getValue=' + result.getValue(search_columns[0]) +' name=' +result.getText(search_columns[0]) Any idea

What is the ID of the column you want to read?

I want to find the column that has the name "SO" and return the corresponding search_columns[???]

What field is the column named "SO" reading?

In this case it's the first one, but if they change it, like they were about to do it, the script would have gone crazy

OK let me ask a different way. What field from the Sales Order does your script expect to be first in the search columns?

It's a saved search

I understand

Whatever the order is, I want to know the name of the column, That's all I'm looking for

Column instances have a

name

and a

label

property

You can also load the search, add the column you need with a refence ID/Name you know, then run the search and get your results. This means that even if somebody remove the column from the search you still get your column value.

Possible but it will be a performance nightmare. I can use result.*getValue*(search_columns[0]) I'm searching for the name of that column something like result.*getText*(search_columns[0])

If that's the solution, I will be ashame of me. Thanks a lot

I imagine you'll have to do something like

let theIndex = search_columns.find(c => c.label === 'SO')
// ...
result.getValue(search_columns[theIndex])

Loading/adding a column and running the search should not be a big performance penalty.

I tried label, name, find and none worked 😞

You're going to have to share code

I am guessing your SO number is tranid. So try this, result.getValue({name : 'tranid'})

^ This is what I was desperately trying to uncover by asking what field "SO" was

Thanks all This result.getValue({name : 'tranid'}) was the answer