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, How can I pull a "User Note" content, it shows as a "note" field but I do not see it as one of the columns.
Do I need to join with another table?

SELECT
	note.activity,
	note.entity,
	note.externalId,
	note.folder,
	note.id,
	note.item,
	note.media,
	note.custrecord_nx_asset,
	note.custrecord_nx_note_idempotency_key,
	note.accountingPeriod,
	note.topic,
	note.transaction
FROM
	note
WHERE
	note.transaction = '916983'

I think the field you want is note.note
<https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_1/script/record/note.html>

<@U01LR2ZSG1X> I've tried that as well, it doesn't work