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?

System Notes V2 worked for me. You may want to ask in the suiteanalytics channel if you have no luck here.

sql is case insensitive, it does not matter

@NElliott What tool are you using for your queries?

Tim's one

@Jesper M Tim's https://timdietrich.me/blog/netsuite-suiteql-query-tool-2021-2/

Thank you! Is it for free?

btw, you can view the permissions needed here, really helps: https://timdietrich.me/blog/netsuite-suiteql-tables-permissions-reference/

Wonderful, thank you

Also look here: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N326485.html in the xls file

Can you export the results to excel? I can't seem to find that option

yes

Not getting my head around the table references.. there is a query in the remote catalogue in the suitelet that is: "-- Contributor: Tim Dietrich (timdietrich@me.com) -- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-journal-entries-gl-impact/ SELECT BUILTIN.DF( TransactionAccountingLine.Account ) AS Account, TransactionAccountingLine.Debit, TransactionAccountingLine.Credit, TransactionAccountingLine.Posting, TransactionLine.Memo FROM TransactionAccountingLine INNER JOIN TransactionLine ON ( TransactionLine.Transaction = TransactionAccountingLine. Transaction ) AND ( TransactionLine.ID = TransactionAccountingLine. TransactionLine ) WHERE ( TransactionAccountingLine.Transaction = 88417362 ) AND ( ( TransactionAccountingLine.Debit IS NOT NULL ) OR ( TransactionAccountingLine.Credit IS NOT NULL ) ) ORDER BY TransactionLine.ID" But, there is no table called "TransactionLine" in the table reference..