hi i have this below parsed result {"subsidiarynohierarchy.CUSTRECORD_BOX_FULFILLMENT":{"value":"2","text":"Air Bm"}} Its a join on the saved search meaning ({name : 'subsidiarynohierarchy', join : 'CUSTRECORD_RFS_PACKED_BOX_FULFILLMENT'}) Now i want to take the value using below code log.debug('sub',searchResult.values['custrecord_box_fulfillment.subsidiarynohierarchy']); but it returns nothing. Could anyone please help me?

Please go through the search module and its object. Netsuite Object != the parsed object that you see in logs. Search Module: (See the column object parameters) https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4345764122.html SuiteScript Example: (understand how to fetch the value for a column from a search row) https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_0304061100.html

its the result i get in the map function after parsed. is that you mean?

if its a parsed JSON. Then you can do it like this

parsedJson={  "subsidiarynohierarchy.CUSTRECORD_BOX_FULFILLMENT": {
    "value": "2",
    "text": "Air Bm"
  }
}
myValue = parsedJson["subsidiarynohierarchy.CUSTRECORD_BOX_FULFILLMENT"]["value"]

this is the error i got TypeError: Cannot read property "subsidiarynohierarchy" from undefined

can you please provide your script

you mean complete script?

yes at least the input and map stage

Thank you raghav I got it. now its working.