Anyone here have experience with quirks related to Long Text fields in SuiteQL? I can't seem to do anything with grouped queries that involves a Long Text field.

The maximum string length is 4000 characters, you'll get errors if any value exceeds it in any stage of running the query

@Shai Coleman Thank you, but that's not the issue here -- I only had one record created, and the value in that Long Text field was only 9 characters long. I can query the table itself just fine, but when I run any query that involves grouping / aggregate / analytic functions, it gives me an Invalid Search error. A Text Area field with equal values does not create the issue.

Maybe try running

SUBSTR

on it first

I know you cannot GROUP BY long text in Saved Search, perhaps SuiteQL has the same limitation?