cloudant nosql db query with regex

Question

I have a cloudant nosql db with some records like this:

{
 "role": "utente",
 "nome": "Rocco",
 "cognome": "Di Vitto",
 "team": "sap pm-cs",
 "company": "wrestling",
 "appManager": "john Ford",
 "teamLeader": "Rendy Orton, Colombo M.R."
}

I would like to query my db with a $regex the teamLeader field, passing a single string that matches either with "Randy Orton" or "Colombo M.R." but I can't figure out the regex for matching two comma-delimited strings. I've tried reading Erlang queries structure but I didn't find the solution. Some help would be very useful. thanks in advance

i composed this query { "selector": { "teamLeader": { "$.+(?|(Colombo M\.R\.)|(Rendy Orton)).+" : "Randy Orton" } } } but it didnt worked. — vsam490
– vsam490, Commented Feb 8, 2018 at 11:40

vabarbosa · Accepted Answer · 2018-02-08 14:14:54Z

2

when supplying regular expressions you should be using the $regex operator. have you tried something like this:

{
   "selector": {
      "teamLeader": {
         "$regex": "(Colombo M.R.)|(Rendy Orton)"
      }
   }
}

answered Feb 8, 2018 at 14:14

vabarbosa

7061 gold badge4 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

cloudant nosql db query with regex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related