This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Any ideas on why a runSuiteQL().asMappedResults() would run a query just fine but runSuiteQLPaged() would not? I'm getting "SSS_SEARCH_ERROR_OCCURRED: Search error occurred: Invalid or unsupported search"

Untitled.sql

It appears to be the ORDER BY-clause that caused it.

I am sure that ORDER BY is not supported wirh pagged run

I run Paged with Order By, I believe the problem is you can't use the Alias in the Group By.  Try 'Group by MAX(T.tranDate) DESC'

But I didn't use an alias in the group by.

I have my head in my own SuiteQL and working on the grouping portion now....sorry for that

I didn't actually need the order by, so I just deleted it, but it sounds very plausible that it doesn't like aliases in the ORDER BY. :+1:
Another fun thing I found out was that if I had aliases with spaces and then wrapped that query inside another ROWNUM query (to be able to run runSuiteQL().asMappedResults() for 5000 results at a time. It failed. It worked when removing the spaced in the aliases.