I'm trying to get System Notes via SuiteQL (tried both systemnote and systemnote2 tables) but get empty list. Is it possible? do i need to enable something?

try adding a where clause

can you please give an example?

try even something as simple as

where rownumber < 10

thanks mate i'll send updates 🙂

if that doesn't produce results, maybe the account you're using to query lacks sufficient permissions

what permissions do i need? unfortunatly it did not work 😞

try running the query as Administrator role just to ensure it will work with sufficient permissions

Are you querying a prod or Sandbox account? System notes get wiped on a refresh. They start generating again in Sandbox for things that have happened since the refresh, but if you have a fresh refresh, you might get zero system notes.

i am running in sandbox. what is refresh? also, how long does the login audit logs and systemnotes last until wipe out?

A Sandbox refresh is copying a snapshot of your production instance over to your Sandbox instance so the data is fresh. Often done when you want to test something, usually with the most up to date data. On a NS refresh, the login audit information and system notes present in Production are removed so when your Sandbox is first updated, it will not have any of that data for any record (or most records anyway). However, once you start logging in to Sandbox and/or changing records, the System Notes will start to regenerate. A way to test if this is the issue in your instance would be to go into the UI in Sandbox and change the name of a customer or vendor or something. That will generate system notes entries. If your query is still blank, then it's some other issue.