is there an aggregate function available in suiteql to aggregate into a list or into a big string by concatenation

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that there is no direct equivalent for the

ns_concat

function in SuiteQL. The

LISTAGG

function, which is commonly used in other SQL dialects for similar purposes, is also not supported in SuiteQL. One user suggested using the "||" operator to concatenate two strings, but this does not aggregate multiple rows into one row based on some grouping, which is what

ns_concat

does in a NetSuite saved search. Another user suggested using a subquery or joining multiple searches within SuiteScript, but this might not be the most efficient solution, especially if you are trying to avoid multiple queries. In conclusion, it seems that there is currently no aggregate function available in SuiteQL that can aggregate into a list or into a big string by concatenation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******