Identifying the null values in a Collection

[Amarendra_Krishna]

Hello Everyone,

I would like to identify the null values in the collection without using the specific key. For example in the below mentioned, without using the keys profession/education/etc., i want to get the list of the keys which are having null values across the collection. Is it possible to get the details as I need?

{
        "_id" : ObjectId("528f22140fe5e6467e58ae73"),
        "user_id" : "user1",       
        "sex" : "Male",
        "age" : 17,
        "date_of_join" : "16/10/2010",
        "education" : "M.C.A.",
        "profession" : "CONSULTANT",
        "interest" : "MUSIC"
}
{
        "_id" : ObjectId("528f222e0fe5e6467e58ae74"),
        "user_id" : "user2",
        "sex" : null,
        "age" : 24,
        "date_of_join" : "17/10/2009",
        "education" : "M.B.A.",
        "profession" : "MARKETING",
        "interest" : null
}
{
        "_id" : ObjectId("528f22390fe5e6467e58ae75"),
        "user_id" : "user3",
        "sex" : "Female",
        "age" : 19,
        "date_of_join" : "16/10/2010",
        "education" : "M.C.A.",
        "profession" : null,
        "interest" : "ART"
}
{
        "_id" : ObjectId("528f22430fe5e6467e58ae76"),
        "user_id" : "user4",
        "sex" : "Female",
        "age" : 22,
        "date_of_join" : "17/8/2009",
        "education" : null,
        "profession" : "DOCTOR"
}

[steevej (Steeve Juneau)]

Have you solve your other issue:

Update the Key in the nested array

If you look at the $map documentation, you will see it returns an array with the applied results By doing you explicitly ask to $set history.status to an array. So it is totally normal that Most likely you do not $set/$map the appropriate field. But since your sample input document is not formatted correctly we are not to cut-n-paste it to experiment.

If you did share the solution or mark one of the reply as the solution.

This following post also needs closure:

Update the key data type from string to int64

If you look at the $map documentation you will read the following about $$this: A name for the variable that represents each individual element of the input array. If no name is specified, the variable name defaults to this. In you sample document, the field fulfill is an array of objects. You $map using input:$fulfill and $toLong:$$this.tagSerialNumbers, but tagSerialNumbers is an array and this is why you get: But I already mentioned: An hint to the solution was also mentioned:

As mentioned in your other posts:

@steevej

Please read Formatting code and log snippets in posts and update your sample documents and pipeline so it is easier to understand and to cut-n-paste for experimentation.

[Amarendra_Krishna]

Can any one provide the inputs for this query?

[steevej (Steeve Juneau)]

I will give you a hint. Look at $objectToArray then $match on v : null.

But that is all I will give you until you do your part to keep this forum useful. And your part is to supply closure for your other threads as requested in my previous post.