has anyone queried user notes on a customer record...
# suiteql
r
has anyone queried user notes on a customer record? The Note 'table' for me doesnt look like the documentation here. https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/script/record/note.html
t
I've run into this before, and I think the issue is that we don't have full access to the columns in that table (via SuiteQL). Try running these, and you'll see that the columns do exist , but aren't available:
Copy code
SELECT TOP 10 Note.Title FROM Note ORDER BY ID DESC
Copy code
SELECT TOP 10 Note.Note FROM Note ORDER BY ID DESC
The specific error is, "_Search error occurred: Field 'Title' for record 'note' was not found. Reason: NOT_EXPOSED - Field is marked as internal for channel SEARCH_" I don't think we have a way to expose those columns.
r
Copy code
Field 'Note' for record 'note' was not found. Reason: NOT_EXPOSED
thanks for help. guess Ill use saved search restlet. guess they try to prevent some data exports or integrations