How can I use a CTE from within a subquery? NS-SuiteQL-Reporter wraps all queries for rownumbering/offsets. If I run the query outside of the wrapper it returns results, but within the subsubquery I get blanks for everything. github.com/watzen/NS-SuiteQL-Reporter/blob/…/index.ts#…

I don't have an answer to your specific query example, but have you read this post? timdietrich.me/blog/netsuite-suiteql-query-pagination

I saw that report. There are other changes I might make to my copy of the repository.