This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi guys, I am using the `N/query` module and I am having some issues with joins. I am creating two joins one to a child of the current record and one to a parent of the current record. I keep getting `"Search error occurred: Record Join '&lt;CHILD_RECORD&gt;' for record '&lt;CURRENT_RECORD&gt;' was not found.`

On the join property are you using field name (foreign key)?

Paste the syntax of the join here if you dont mind.

`*var* parcelcontent *=* parcelquery.join({ fieldId : 'custrecord_parcel_content_parent'});`

Any chance you have tried `Netsuite: Workbook to SuiteQL` chrome extension, you can build your query in the UI and just export it to code.