mongodb how to find a length of string in a array

Question

hi i have a little problem, i hope someone know that how can i deal with this problem.

  {
    "isim": "This is topic - 2",
    "resim": "anywhere2.png",
    "ozellik": {
      "detay": ["qv", "asv", "asd" , "vx"],
      "bilgi": ["xc", "bv", "hjm" , "sax"]
    }
  },

  {
    "isim": "This is topic - 1",
    "resim": "anywhere.png",
    "ozellik": {
      "detay": ["sa", "as", "de", "ed"],
      "bilgi": ["bv", "cv", "asd", "dsa"]
    }
  }

this is my db, I can do that: bilgi[2] like this

{ $project: {
        _id: 0,
        isim: 1,
        boyut: { $arrayElemAt: ["$ozellik.bilgi", -2] },
      }}

and this code return following lines:

{
    "isim": "This is topic - 2",
    "boyut": "hjm"
  },

  {
    "isim": "This is topic - 1",
    "boyut": "asd"
  }

here is, i want to know what is length of "hjm" or "asd"

this is not work for me : String field value length in array in mongoDB

and i try this :

boyut: { $strLenCP : {$arrayElemAt: ["$ozellik.bilgi", -2]} },

and node js is say that, Screenshot

MongoError: $strLenCP requires a string argument, found: missing

what is wrong from that code ? i.hizliresim.com/trfnqg.png

Berkoo
– Berkoo

2020-09-10 16:58:53 +00:00
Commented Sep 10, 2020 at 16:58 — Berkoo
– Berkoo, Commented Sep 10, 2020 at 16:58

turivishal · Accepted Answer · 2020-09-10 19:21:03Z

1

Its happening when it search for $arrayElemAt position -2, if array element size is less than or equal to 1 then, this function will return null, and $strLenCP operator supports only string type,

You can use $ifNull to prevent this error,

  {
    $project: {
      _id: 0,
      isim: 1,
      boyut: {
        $strLenCP: {
          $ifNull: [
            { $arrayElemAt: ["$ozellik.bilgi", -2] },
            ""
          ]
        }
      }
    }
  }

Playground

edited Sep 10, 2020 at 19:21

answered Sep 10, 2020 at 15:17

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

mongodb how to find a length of string in a array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related