Using LISTAGG or NS_CONCAT in a SuiteQL query
I am attempting to concatenate all the rows in a column into a single comma separated string, but I receive an “Invalid or unsupported search” error anytime I try to use the LISTAGG or NS_CONCAT functions in my query string. It works properly in a Saved Search using the following formula:
But the following SuiteQL query throws an error:
SELECT LISTAGG(number, ‘,’) FROM transaction WHERE recordtype=’salesorder’;
Any help concatenating rows in a SuiteQL query would be greatly appreciated.