Empty reply when querying system notes table with ...
# ask-stanley-ai
b
Empty reply when querying system notes table with sql api
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that you can query the System Notes table using SuiteQL. However, some users have reported getting an empty list when trying to do so. Here are some suggestions that might help: 1. Make sure you are using the correct table name. In SuiteQL, the table names are case insensitive. So, you can use either
systemnote
or
systemnote2
. 2. Check the permissions needed to access the System Notes table. You can find a reference for the permissions needed for each table in NetSuite SuiteQL [here](https://timdietrich.me/blog/netsuite-suiteql-tables-permissions-reference/). 3. If you are still having trouble, you might want to try using a different tool for your queries. One user suggested using Tim Dietrich's SuiteQL Query Tool, which you can find [here](https://timdietrich.me/blog/netsuite-suiteql-query-tool-2021-2/). 4. If you want to use System Notes as part of a search criteria, you can use a
systemnotes
join. More information about this can be found [here](https://system.na1.netsuite.com/app/help/helpcenter.nl?fid=section_4345777107.html). 5. Unfortunately, System Notes are not available to pull using a SOAP request. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844567597
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830072522
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823398232
Please provide your feedback on this answer.