Quick brain fart, I have a search that joins in th...
# suitescript
n
Quick brain fart, I have a search that joins in the Customer internalid to a search using
searchModule.createColumn({ name: "internalid", join: "customerMain", label: "Internal ID" }),
later on as I run the search I log each search result
{"recordType":"salesorder","id":"518560","values":{"internalid":[{"value":"518560","text":"518560"}],"transactionname":"Sales Order #202144","trandate":"8/18/2020","customerMain.internalid":[{"value":"73960","text":"73960"}],"formuladate":"8/18/2020"}}
But for some reason the following doesn't work,
var customerId = result.getValue({ name: 'customerMain.internalid' });
customerId is always null. I think its something obvious, yet it escapes me...
b
use the join parameter from Result.getValue(options)
n
Slightly embarrassed, thanks again.