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

Hello, in a `GROUP BY` query I am trying to use something equivalent to PostgreSQL’s `string_agg` or Oracle’s `LISTAGG` , I noticed that there is a function `CONCAT` in <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_158513731864.html#SuiteQL-Supported-and-Unsupported-Functions> , that could combine the strings but it’s not working for me giving back
```       %{
         "detail" =&gt; "Invalid search query. Detailed unprocessed description follows. Search error occurred: Invalid or unsupported search.",
         "o:errorCode" =&gt; "INVALID_PARAMETER",
         "o:errorQueryParam" =&gt; "q"
       }```
(for the record COUNT works), is there a way to combine a resulting list of strings into one? Preferably with a delimeter I can set

Ahh I believe it’s meant to be used with 2 arguments, not group by

I wonder if there is at least something that I could use with group by to create an array of something

<https://netsuiteprofessionals.com/blog/answer/re-using-listagg-or-ns_concat-in-a-suiteql-query-2/>

LISTAGG example. Please note that the maximum concatenated string is 4000 characters.
```WITH t2 AS (
  SELECT     transaction.id AS transaction_id, transactionline.uniquekey
  FROM       transaction
  INNER JOIN transactionline ON (transactionline.transaction = transaction.id)
  FETCH FIRST 1000 ROWS ONLY
)
SELECT   t2.transaction_id,
         LISTAGG(t2.uniquekey, ', ') WITHIN GROUP (ORDER BY t2.uniquekey) AS transactionline_uniquekeys
FROM     t2
GROUP BY t2.transaction_id
ORDER BY t2.transaction_id```


Thank you!!! I was so frustrated with this one, just tested it and works like a charm!! :heart: