Query object method · N/query

joinTo()

Query.joinTo(options)

Creates an explicit directional join relationship to another component from this component (a forward join).

Implementation
Not started
Design
Open for proposals suggest how it should read
Proposals
A
Signature
Query.joinTo(options)
Module
N/query
Returns
query.Component
Governance
None
Script types
Client and server scripts
Version
SuiteScript 2.x, documented for 2.1; since NetSuite 2018.2
call shapefrom Oracle's parameter table
1objQuery.joinTo({2    fieldId: /* string, required */,3    target:  /* string, required */4});
Oracle reference for this method
ParameterTypeRequiredDescription
options.fieldIdstringrequiredThe column type (field type) that joins the parent component to the new component. Obtain this value from the Records Catalog. The Records Catalog lists every record type and field that is available using SuiteAnalytics Workbook and the N/query module. For more information, see Records Catalog Overview .
options.targetstringrequiredThe query type of the component joined to this component. This value sets the Component.target property. This value can be described as the relationship of this component, and it determines the target query type of the newly joined component.
B

No Mynt syntax yet.

Nothing in the language compiles to Query.joinTo(options) today. How should it read?

C

Competing syntax for joinTo, from GitHub Discussions. Select two or more to compare them side by side.

All discussions

Loading proposals from GitHub…

D

Write the Mynt you wish you could write.

A good proposal shows the syntax, the SuiteScript it should become, and argues for it: why it is clearer, how it fits the rest of the language, what it makes harder.

  • Clarity. Does it say what happens, without ceremony?
  • Consistency. Does it read like load, save and Ref[field]?
  • Expressiveness. Does it cover the cases people actually write?
  • Honesty. Does it hide a NetSuite cost, such as governance, that a reader should see?

N/query · Query.joinTo(options)

Suggest syntax for joinTo