How to search for a specific string in couchbase array

Question

I have JSON documents of below format:

{
  "id":"1005",
  "config":{
      "properties":["ABC_001", "DEF_002", "PQR_009"]
   }
}

How can I search for a particular config.properties that matches pattern '%ABC%' and has an id=1005. In the above case, my output should be

config.properties:ABC_001

Johan Larson · Accepted Answer · 2018-12-18 12:26:57Z

3

This gets you close:

select prop as `config.properties` 
from test unnest config.properties prop
where test.id = "1005" and prop like '%ABC%'

Here's the output:

[
  {
    "config.properties": "ABC_001"
  }
]

answered Dec 18, 2018 at 12:26

Johan Larson

1,9001 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1