This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi there, I am just trying to pull values from a saved search using the .getValue() function, however for the columns such as Item : Internal ID, I am unable to provide the correct name for it to return a value? It only returns null.

So my call search.getValue({
          name: 'quantity'
        }); works and returns quantity value as expected.

search.getValue({
          name: 'Item : Internal ID'
        });

getValue also takes column objects. Use result.columns in a loop and pass that to getValue like: getValue(columnObj)

columnObj includes name or label properties so you can use those to tell which field you are getting

Thanks Adolfo, really appreciate your help :slightly_smiling_face:

what you are doing is a join.

If this gives you quantity,
```result.getValue({name: 'quantity'});```
then this will give you the internalId of the item:
```result.getValue({name: "internalid",join: "item"})```

That is fantastic! Thank you so much Raghav!!