Counting the email and phone more than 3 and showing the output as _id,email count,phone count

Asked Jul 08 '17 at 07:40

Active Jul 08 '17 at 09:41

Viewed 26 times

I want to get _id,count of email,count of phone and filter condition is documents having email or phone count more than 3. Any help will be appreciated.

Below is the sample document format:

{

    "_id" : "23243pbfg1-47a9-9d98-23423hffngfkl",

     "key" : {
             "phone" : [
                     "1234567890",
                     "9999999999",
                     "9888888888",
             ],
             "email" : [
                     "[email protected]",
                     "[email protected]",
                     "[email protected]",
                     "[email protected]"
             ]
     }

edited Jul 08 '17 at 09:41

Neil Lunn

148,042
36
346
317

asked Jul 08 '17 at 07:40

Deepak Sharma

`.find({ "$or": [{ "key.phone.3": { "$exists": true } }, { "key.email.3": { "$exists": true } }] })`. Which basically asks "if the third index position ( 4th element ) is actually present", and that means the length is greater than 3. – Neil Lunn Jul 08 '17 at 07:43
Thanks @Neil. It worked. :) – Deepak Sharma Jul 08 '17 at 08:11
If i want to get the _id,email count,phone count of a document. Any suggestions. – Deepak Sharma Jul 08 '17 at 08:12

Counting the email and phone more than 3 and showing the output as _id,email count,phone count

0 Answers0