Conditional $sort in aggregation

Question

I wanted conditional sort on price, There are two types of price in the database, so I am checking whether the sellType is fixed price or bid,

if(sellType===fixed price) then I want to fetch the normal price but, if(sellType===bid) then I want to fetch the price from the object which is stored at 0th position in the array.

So I've tried to make aggregated query, sharing my code snippet

{
  $addFields: {
    sortedPrice: {
      $cond:  {
        if: {
          $eq: ["$itemDetail.sellType","fixed price"]
        },
        then: '$itemDetail.price',
        else:  '$itemDetail.bidInfo[0].price',
      }
    }
  }
}

I've tried all the possible solutions but not able to fetch the price from the bidInfo array. bidInfo is an array of objects but I want only the 0th position object (price to be very precise)

Try with $arrayElemAt, see stackoverflow.com/questions/61425173/… — Joe
– Joe, Commented Jun 2, 2021 at 20:01

Shaiv · Accepted Answer · 2021-06-02 20:45:51Z

0

You can try with $arrayElemAt,

 {
        $addFields: {
            sortedPrice: {
                $cond: {
                    if: {
                        $eq: ['$itemDetail.sellType', 'fixed price'],
                    },
                    then: '$itemDetail.price',
                    else: { $arrayElemAt: ['$itemDetail.bidInfo.price', 0] },
                },
            },
        },
    },

answered Jun 2, 2021 at 20:45

Shaiv

512 bronze badges

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

Collectives™ on Stack Overflow

Conditional $sort in aggregation

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