Concat strings of an array using N1ql

SQL++
,
1

Hi Team

I have sample document as below, I would like to write a n1ql query that would return the concatenated value of all the authors in the below document.

Can I please know how to achieve that using n1ql?

"books": {
  ...
  ...
  "authors": [
    "AAAA",
    "BBBB",
   "CCCC"
  ],
  ...
  ...
}

Regards,
Venkat

2

https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/arrayfun.html

3

@maciej.tomaszewski I have gone through it already, but unfortunately I don’t see any array function supporting that.

4

SELECT CONCAT2(",", books.authors) FROM bucket
I don’t know your db structure but it would be sth like this. Please play with it a bit, you will figure it out :wink:

1 Like
5

As @maciej.tomaszewski suggested use CONCAT2() (CB 6.5.0) String Functions | Couchbase Docs.

6

@maciej.tomaszewski and @vsr1

Thanks for the info but unfortunately we are still not on 6.0.2 so we don’t have a CONCAT2 function available

7

@sri_ram ,

Follow suggestion here Array concatenate in n1ql

8

Thanks that worked

Regards,
Venkat