How to check empty array in if condition in mongodb query?

Question

I am trying to find whether the array is empty or not by writing following mongodb projection query with if else condition.

                [
                  '$project' => [ 
                      '_id' => 1.0,
                      'Name' => 1.0,
                       'AllotmentsDetails' => 1.0,
                       'NonExpiredAllotmentsOfRoomWithCheckoutZero' => 1.0,
                       'NonExpiredAllotmentsOfRoomWithCheckoutOne' => 1.0,
                       'NonExpiredAllotmentsOfRoom' => 1.0,      
                       'RecentAllotmentsDetails' =>  [
                            '$cond'=> [
                              'if'=> [
                                '$not' => ['$NonExpiredAllotmentsOfRoom' => [ '$size' => 0 ]]
                               ],
                               'then' => ['$arrayElemAt' => ['$NonExpiredAllotmentsOfRoom', -1 ]],
                               'else' => []
                              ]
                        ]    
                ]]

Basically I am trying to check whether '$NonExpiredAllotmentsOfRoom' is empty or not. if it is empty it should return empty array otherwise it should return last element of '$NonExpiredAllotmentsOfRoom'. The above code is throwing error message "Unrecognized expression '$NonExpiredAllotmentsOfRoom". Please help !!!

Can you post a few sample data?

verisimilitude
– verisimilitude

2019-11-15 08:51:17 +00:00
Commented Nov 15, 2019 at 8:51 — verisimilitude
– verisimilitude, Commented Nov 15, 2019 at 8:51

vicky · Accepted Answer · 2019-11-15 08:53:19Z

2

RecentAllotmentsDetails =>  {
                              $cond: { if: { $ne: [ 
                              "$NonExpiredAllotmentsOfRoom", [] ] }, 
                               then: ['$arrayElemAt' => 
                                      ['$NonExpiredAllotmentsOfRoom', -1 ]] ,
                               else: []
                                }   

                              }

try this in your pipeline

answered Nov 15, 2019 at 8:53

vicky

4152 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to check empty array in if condition in mongodb query?

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