Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to retrieve the "items" sublist fields using SuiteScript - N/Search?
Hello guys!
Hope you all are doing great!
I'm trying to retrieve sublist values using Search module in SuiteScript.
In this example I need to retrieve the "items" sublist fields using the search method. But the 'join' is not working.
Something like that:
``
const pagedPurchaseOrder = Search.create({
type: Search.Type.PURCHASE_ORDER,
filters: [["internalId", Search.Operator.IS, 1585660]],
columns: [
"tranid",
"entity",
"trandate",
"amount",
"total",
"statusref",
"custbody6", // Forma de pagamento
"custbody_sit_transaction_l_cond_pagto",
Tagged:
0