searchResult.getValue({name: 'custitem_last_purcha...
# suitescriptc
creece
11/26/2019, 8:34 PMsearchResult.getValue({name: 'custitem_last_purchase_rate', join: 'item'})
☝️ 2
b
b
11/26/2019, 8:46 PMCannot find function getValue in object [object Object].
e
erictgrubaugh
11/26/2019, 8:49 PMI assume you have done the search in one stage and are retrieving the result in another
erictgrubaugh
11/26/2019, 8:49 PMwhich means the result has been stringified, and it will no longer have its
getValueb
b
11/26/2019, 8:50 PMcorrect, search is done in getInputData
e
erictgrubaugh
11/26/2019, 8:50 PMRecommend deserializing the result and logging that out to the log to see its structure
b
b
11/26/2019, 8:50 PMthat is what I thought but was suggested I try
e
erictgrubaugh
11/26/2019, 8:50 PMI believe it's something like
result.joinname_fieldnameerictgrubaugh
11/26/2019, 8:51 PMor perhaps
result.values.joinname_fieldnameerictgrubaugh
11/26/2019, 8:51 PMeither way, I'd log it out to make sure
b
b
11/26/2019, 8:52 PMI tried logging it but I got [object Object] I did:
var results = JSON.parse(context.value);
and then logged results.values
e
erictgrubaugh
11/26/2019, 8:52 PMIs this in
mapb
b
11/26/2019, 8:52 PMyes
e
erictgrubaugh
11/26/2019, 8:53 PMWhat does your log statement look like?
b
b
11/26/2019, 8:55 PMlog.debug({
title: 'results',
details: results.values
});
e
erictgrubaugh
11/26/2019, 8:56 PMOdd; looks right to me
erictgrubaugh
11/26/2019, 8:56 PMwouldn't expect to see
object Objects
stalbert
11/26/2019, 8:57 PMit just dawned on me that I never use that form for
log.debuge
erictgrubaugh
11/26/2019, 8:59 PMI've never used the non-object forms since switching to 2.0 ¯\_(ツ)_/¯
b
battk
11/26/2019, 8:59 PMLog context.value without parsing it
b
b
11/26/2019, 9:00 PMI'll give that a try
b
11/26/2019, 9:05 PMThanks @battk that helped. {"recordType":"salesorder","id":"1533485","values":{"transactionname":"Sales Order #539673","item":{"value":"11902","text":"1004450"},"quantity":"3","type.item":{"value":"Assembly","text":"Assembly/Bill of Materials"},"custitem_last_purchase_rate.item":".90"}}
b
11/26/2019, 9:06 PMresults.values.field.join looks like
b
11/26/2019, 9:30 PMWell that didn't work
Cannot read property \\\"item\\\" from undefined\
j
jkabot
11/26/2019, 9:35 PMif you look carefully at the structure of the object you logged you'll see that the property name actually contains a
. Copy code
var rate = results.values["custitem_last_purchase_rate.item"];b
b
11/26/2019, 9:35 PMok, thanks!