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

If I'm on a customer and do getValue("shipcountry") it returns "US". How can I take that value and get countries id so that I can use it on a search

You probably want the *`uniquekey`* from this result
```var result = query.runSuiteQL({
    query:"SELECT * from country where id = ?"
    ,params:["US"]
}).asMappedResults();```