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:

LISTAGG({number}, ‘,’)

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.

Rookie Asked on February 15, 2021 in SuiteAnalytics.
Add Comment
1 Answer(s)

Not sure if this helps but in a saved search ns_concat only works with a Minimum or Maximum Summary Type.  The field subjected to the ns_concat function cannot be grouped by itself

Rookie Answered on February 15, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor