how i get item's usernotes using suiteql

AI generated answer (using internal Slack threads):

To get item's user notes using SuiteQL, you would need to query the

transaction

table and join it with the

note

table. The

note

table contains the user notes. Here is a sample SuiteQL query:

sql
SELECT T.id, N.note 
FROM transaction T 
JOIN note N ON T.id = N.transaction 
WHERE T.id = YOUR_ITEM_ID

Replace

YOUR_ITEM_ID

with the actual ID of the item you want to get the user notes for. Please note that the

note

table might not contain all the user notes you are looking for, as not all sublists support SuiteScript. You can check the available sublists that support SuiteScript in the NetSuite Help Center under the section 'Sublist Types'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******