Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

Component.join(options)

{Component}.join({fieldId: {string*}})

N/query Module
Component.join()
Method Description: Creates a join relationship. This method is an alias to Component.autoJoin(options). Use the method query.create(options) to create your initial query definition (query.Query). The initial query definition uses one query type. For available query types, see query.Type. After you create the initial query definition, use Query.autoJoin(options) to create your first join (query.Component). Then use Component.join(options) to create each subsequent join (query.Component). The N/query module supports the same record types that are supported by the SuiteAnalytics Workbook interface. For more information, see Available Record Types.
Returns: query.Component
Supported Script Types: Client and server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: None
Module: N/query Module
Parent Object: query.Component
Sibling Object Members: Component Object Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Component.join(options)

Example:

// Code Example 1
// Add additional code
//...
var myTransactionQuery = query.create({
type: query.Type.TRANSACTION
});

var myEntityJoin = myTransactionQuery.join({
fieldId: 'entity'
});

myTransactionQuery.columns = [
myEntityJoin.createColumn({
fieldId: 'subsidiary'
})
];

myTransactionQuery.sort = [
myTransactionQuery.createSort({
column: myTransactionQuery.columns[0],
ascending: false
})
];

var results = myTransactionQuery.runPaged({
pageSize: 10
});
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510784833.html